| From: | Ian Barwick <barwick(at)gmx(dot)net> |
|---|---|
| To: | Francisco Reyes <lists(at)natserv(dot)com>, pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Listing schemas |
| Date: | 2003-03-01 00:18:03 |
| Message-ID: | 200303010118.03371.barwick@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-03-01 00:46:41 | multiple conditions in same plpglsql IF block |
| Previous Message | Oliver Elphick | 2003-02-28 23:45:17 | Re: automatic creation of oid |