Re: Schemas in a database?

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Schemas in a database?
Date: 2010-08-06 01:18:56
Message-ID: 4C5B6300.8050601@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Leon Starr 2010-08-06 04:21:00 Best way to test/develop lots of nested functions?
Previous Message Vibhor Kumar 2010-08-06 00:30:14 Re: Schemas in a database?