# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1427208861 -7200
# Node ID d2b977ccbf4f800d95c28f7f533b7a6f318ff019
# Parent  6163ba5907d4cfd0dbf305165dbb577fd0dd5e89
List databases.

diff -r 6163ba5907d4 -r d2b977ccbf4f postgre.rst
--- 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.