Postgres Pro
Downloads
Home   >   mailing lists

Schemas in a database? - Mailing list pgsql-novice

From Mladen Gogala
Subject Schemas in a database?
Date
Msg-id 4C5B3EC6.1050206@vmsinfo.com
Whole thread Raw
Responses Re: Schemas in a database?  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Re: Schemas in a database?  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Rikard Bosnjakovic
Date:
Subject: Re: Table-design for categories, suggestions needed
Next
From: Vibhor Kumar
Date:
Subject: Re: Schemas in a database?