changeset 1702 | d2b977ccbf4f |
parent 1701 | 6163ba5907d4 |
child 1703 | a85cc266dbdf |
--- a/postgre.rst Tue Mar 24 16:52:00 2015 +0200 +++ b/postgre.rst Tue Mar 24 16:54:21 2015 +0200 @@ -34,6 +34,11 @@ To list databases:: + $ psql -U pgadmin -l + +or:: + + => SELECT datname FROM pg_database WHERE datistemplate = false; => \l To switch databases:: @@ -48,6 +53,7 @@ To list all tables in the current database:: + => SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name; => \dt Using psql client.