To switch databases.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 24 Mar 2015 16:52:00 +0200
changeset 1701 6163ba5907d4
parent 1700 f987c277f760
child 1702 d2b977ccbf4f
To switch databases.
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.
 ==================