| From: | Sean Chittenden <sean(at)chittenden(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Chris <pggeneral(at)designmagick(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: schemas in 7.3b1 |
| Date: | 2002-10-04 03:32:19 |
| Message-ID: | 20021004033219.GG44554@perrin.int.nxad.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Post | 2002-10-04 03:55:07 | Re: to_char(0,'FM999.99') outputs 0. |
| Previous Message | Bruce Momjian | 2002-10-04 02:29:47 | Re: [HACKERS] Anyone want to assist with the translation of |