> > 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?
\dn [PATTERN] list schema names/name spaces
-sc
--
Sean Chittenden