Обсуждение: show ?
How can I get a list of existing databases or tables ? greets bearm
> How can I get a list of existing databases or tables ? \l for databases \d for tables btw, try \? as well ;)
> > How can I get a list of existing databases or tables ? > Check the chapter "System Catalog" in the "Developer's Guide"; esp. have a look at pg_class and pg_database. Christoph Dalitz
Christoph Dalitz <christoph.dalitz@hs-niederrhein.de> writes: >> How can I get a list of existing databases or tables ? >> > Check the chapter "System Catalog" in the "Developer's Guide"; > esp. have a look at pg_class and pg_database. Also see the backslash commands in psql (\dt and \l in this case). regards, tom lane
Say, is it possible to pause the output of the \? command in psql? It just scrolls off the screen for me and I can't see all the options. Thanks, Linn "Tom Lane" <tgl@sss.pgh.pa.us> wrote in message news:26868.1031146820@sss.pgh.pa.us... > Christoph Dalitz <christoph.dalitz@hs-niederrhein.de> writes: > >> How can I get a list of existing databases or tables ? > >> > > Check the chapter "System Catalog" in the "Developer's Guide"; > > esp. have a look at pg_class and pg_database. > > Also see the backslash commands in psql (\dt and \l in this case). > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
This is fixed in 7.3, due out in a few months. --------------------------------------------------------------------------- Linn Kubler wrote: > Say, is it possible to pause the output of the \? command in psql? It just > scrolls off the screen for me and I can't see all the options. > > Thanks, > Linn > > "Tom Lane" <tgl@sss.pgh.pa.us> wrote in message > news:26868.1031146820@sss.pgh.pa.us... > > Christoph Dalitz <christoph.dalitz@hs-niederrhein.de> writes: > > >> How can I get a list of existing databases or tables ? > > >> > > > Check the chapter "System Catalog" in the "Developer's Guide"; > > > esp. have a look at pg_class and pg_database. > > > > Also see the backslash commands in psql (\dt and \l in this case). > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@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