Schemas in a database?

From: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Schemas in a database?
Date: 2010-08-05 22:44:22
Message-ID: 4C5B3EC6.1050206@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rikard Bosnjakovic 2010-08-05 22:50:54 Re: Table-design for categories, suggestions needed
Previous Message Leon Starr 2010-08-05 16:54:49 Re: Trouble accessing %ROWTYPE attributes returned by function