Mladen Gogala wrote:
> How can I see all the schemas in a Postgres database? There is, of course,
> "select distinct schema from pg_tables" but what if the schema contains
> no tables? There is no pg_schemas table.
>
>
And, to answer my own question, the schemas are described in
pg_namespace. Thanks to Tomas Kellerer.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
