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 * +