show ?

Started by Nonameover 23 years ago6 messagesgeneral

Jump to latest

Noname

bearm@poczta.onet.pl

over 23 years ago

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

greets
bearm

dima

_pppp@mail.ru

over 23 years ago

In reply to: Noname (#1)

Re: show ?

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

\l for databases
\d for tables
btw, try \? as well ;)

Christoph Dalitz

christoph.dalitz@hs-niederrhein.de

over 23 years ago

In reply to: dima (#2)

Re: show ?

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

Import Notes

Reply to msg id not found: 20020903153812.D955B47657B@postgresql.orgReference msg id not found: 20020903153812.D955B47657B@postgresql.org | Resolved by subject fallback

Tom Lane

tgl@sss.pgh.pa.us

over 23 years ago

In reply to: Christoph Dalitz (#3)

Re: show ?

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

Linn Kubler

lkubler@ecw2.org

over 23 years ago

In reply to: Tom Lane (#4)

Re: show ?

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...

Show quoted text

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

Bruce Momjian

bruce@momjian.us

over 23 years ago

In reply to: Linn Kubler (#5)

Re: show ?

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