Re: schemas in 7.3b1

Chris <pggeneral@designmagick.com> writes:
> Is there an easy way to get a list of schemas in a database?
> I found the pg_namespace table, but that doesn't tell me what database
> has a particular schema.

Yours.  pg_namespace is local to a database, same as most other
system catalogs.

We had meant to add a \d command for listing schemas in psql, but
both \ds and \dS are taken already :-(.  Any ideas out there for
a reasonable choice?

            regards, tom lane