schemas in 7.3b1 - Mailing list pgsql-general

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.