# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1427208720 -7200
# Node ID 6163ba5907d4cfd0dbf305165dbb577fd0dd5e89
# Parent  f987c277f76062aa0d2713681198f69e2dd70bbf
To switch databases.

diff -r f987c277f760 -r 6163ba5907d4 postgre.rst
--- a/postgre.rst	Mon Mar 23 10:53:06 2015 +0200
+++ b/postgre.rst	Tue Mar 24 16:52:00 2015 +0200
@@ -27,8 +27,18 @@
   https://wiki.debian.org/PostgreSql
     Debian wiki instructions.
 
-List all schemas and tables.
-============================
+List databases, schemas and tables.
+===================================
+
+Default database is ``postgres``.
+
+To list databases::
+
+  => \l
+
+To switch databases::
+
+  => \connect NAME
 
 Schemas::
 
@@ -36,6 +46,10 @@
   => select nspname from pg_catalog.pg_namespace;
   => \dn *
 
+To list all tables in the current database::
+
+  => \dt
+
 Using psql client.
 ==================