author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Thu, 12 Feb 2015 19:41:14 +0200 | |
changeset 1684 | 88f1d11d2adf |
parent 1683 | d99b4a277679 |
child 1685 | f8d84813729c |
postgre.rst | file | annotate | diff | comparison | revisions |
--- 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 * +