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