Postgres Pro
Downloads
Home   >   mailing lists

Re: show ? - Mailing list pgsql-general

From Tom Lane
Subject Re: show ?
Date
Msg-id 26868.1031146820@sss.pgh.pa.us
Whole thread Raw
In response to Re: show ?  (Christoph Dalitz <christoph.dalitz@hs-niederrhein.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Screwy behavior with SUM and multiple joins to same
Next
From: Tom Lane
Date:
Subject: Re: Please help - Keep getting authentication failure when trying to restore database