Postgres Pro
Downloads
Home   >   mailing lists

Thread: show ?

show ?

From
Date:
How can I get a list of existing databases or tables ?

greets
bearm

Re: show ?

From
dima
Date:
> How can I get a list of existing databases or tables ?
\l for databases
\d for tables
btw, try \? as well ;)

Re: show ?

From
Christoph Dalitz
Date:
>
> 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

Re: show ?

From
Tom Lane
Date:
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

Re: show ?

From
"Linn Kubler"
Date:
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

Re: show ?

From
Bruce Momjian
Date:
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