postgre.rst
changeset 1684 88f1d11d2adf
parent 1683 d99b4a277679
child 1700 f987c277f760
--- a/postgre.rst	Thu Feb 12 19:28:09 2015 +0200
+++ b/postgre.rst	Thu Feb 12 19:41:14 2015 +0200
@@ -27,3 +27,12 @@
   https://wiki.debian.org/PostgreSql
     Debian wiki instructions.
 
+List all schemas and tables.
+============================
+
+Schemas::
+
+  => select schema_name from information_schema.schemata;
+  => select nspname from pg_catalog.pg_namespace;
+  => \dn *
+