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 > [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly