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.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions