On Saturday 01 March 2003 00:14, Francisco Reyes wrote:
> I don't see a way to list schemas in a database other than
> select distinct schemaname from pg_tables;
SELECT nspname FROM pg_catalog.pg_namespace
should be a better choice.
> Did I miss something? I was expecting to find something along the lines of
> the \d functions in pgsql.
Which version of psql are you using? There is a \dn to list
schemas in current CVS, and possibly 7.3.2 (but not 7.3.1 or
earlier). Whatever, it's on the way.
Ian Barwick
barwick@gmx.net