Hi all,
Just a quick question.
Is there an easy way to get a list of schemas in a database?
serverlogs=# SELECT version();
version
---------------------------------------------------------------
PostgreSQL 7.3b1 on i586-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)
serverlogs=# CREATE SCHEMA dwarf;
CREATE SCHEMA
serverlogs=# SELECT current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row)
I found the pg_namespace table, but that doesn't tell me what database
has a particular schema..
I checked the developer docs but I couldn't find anything there.
Thanks,
Chris.