Re: Listing Schemas - Revisited - Mailing list pgsql-novice

From Josh Kupershmidt
Subject Re: Listing Schemas - Revisited
Date
Msg-id AANLkTikD7foLSsbj2OKXDm6QMYgt_8VwoyqvA1L5_vp7@mail.gmail.com
Whole thread Raw
In response to Listing Schemas - Revisited  (Chris Campbell <ccampbell@cascadeds.com>)
Responses Re: Listing Schemas - Revisited  (Chris Campbell <ccampbell@cascadeds.com>)
List pgsql-novice
On Tue, Aug 10, 2010 at 1:42 PM, Chris Campbell <ccampbell@cascadeds.com> wrote:
> Hi, a while back I saw a thread about how to list schemas.  The solution
> presented was:
>
> Select * FROM pg_namespace
>
> That’s great except the results include non schema data and no real way
> (that I can tell) to differentiate the actual schemas from the other data.
> In addition, I need to include the schema comments.  So to summarize my
> particular need:  I need to issue a select statement that returns “Schema
> Name” and “Comments” for the given database.

Hrm, what sort of "other data" do you see in pg_namespace? And how about this:

SELECT nspname AS "Schema Name", pg_catalog.obj_description(oid) AS "Comments"
FROM pg_namespace
WHERE nspname !~ '^pg_.*';

Josh

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to trap invalid enum input exception?
Next
From: Chris Campbell
Date:
Subject: Re: Listing Schemas - Revisited