--- 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.
==================