Re: list schema
От | Bruce Momjian |
---|---|
Тема | Re: list schema |
Дата | |
Msg-id | 200212051933.gB5JXAV24599@candle.pha.pa.us обсуждение исходный текст |
Ответ на | list schema (Jie Liang <jie@stbernard.com>) |
Список | pgsql-admin |
We should have one, but the only solution now is: test=> select * from pg_namespace; --------------------------------------------------------------------------- Jie Liang wrote: > Bruce, > > I wonder which command can show all schemas in 7.3? > I mean: > \dt -- show all tables > \l -- show all databases > ?? -- show all schemas > > Thanks. > > > Jie Liang > Software Engineer > St. Bernard Software > 16882 W. Bernardo Dr. > San Diego, CA 92127 > Tel: 858-524-2134 > Fax:858-676-2228 > jie@stbernard.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- 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-admin по дате отправления: