diff -r d99b4a277679 -r 88f1d11d2adf postgre.rst --- 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 * +