postgre.rst
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.