equal
deleted
inserted
replaced
32 |
32 |
33 Default database is ``postgres``. |
33 Default database is ``postgres``. |
34 |
34 |
35 To list databases:: |
35 To list databases:: |
36 |
36 |
|
37 $ psql -U pgadmin -l |
|
38 |
|
39 or:: |
|
40 |
|
41 => SELECT datname FROM pg_database WHERE datistemplate = false; |
37 => \l |
42 => \l |
38 |
43 |
39 To switch databases:: |
44 To switch databases:: |
40 |
45 |
41 => \connect NAME |
46 => \connect NAME |
46 => select nspname from pg_catalog.pg_namespace; |
51 => select nspname from pg_catalog.pg_namespace; |
47 => \dn * |
52 => \dn * |
48 |
53 |
49 To list all tables in the current database:: |
54 To list all tables in the current database:: |
50 |
55 |
|
56 => SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name; |
51 => \dt |
57 => \dt |
52 |
58 |
53 Using psql client. |
59 Using psql client. |
54 ================== |
60 ================== |
55 |
61 |