Re: schemas in 7.3b1
От | Bruce Momjian |
---|---|
Тема | Re: schemas in 7.3b1 |
Дата | |
Msg-id | 200210031606.g93G6Qi07290@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: schemas in 7.3b1 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: schemas in 7.3b1
|
Список | pgsql-general |
Tom Lane wrote: > 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? Is this a TODO item? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: