Postgres Pro
Downloads
Home   >   mailing lists

Thread: Retrieving information from System Tables

Retrieving information from System Tables

From
"Dempsey Bullock"
Date:
Can some tell me how to query for information in the System Catalog.  I
don't see where the documentation states which database to use.  I am using
WINNT 4.0 w/ version 7.1.3.  Thanks in advance!

Re: Retrieving information from System Tables

From
Bruce Momjian
Date:
Dempsey Bullock wrote:
> Can some tell me how to query for information in the System Catalog.  I
> don't see where the documentation states which database to use.  I am using
> WINNT 4.0 w/ version 7.1.3.  Thanks in advance!

System info is in each database separately.  Use psql -E with backslash
commands like \d to see typical queries.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

Re: Retrieving information from System Tables

From
"steve boyle"
Date:
Dempsey,

have a look at:
http://www.postgresql.org/idocs/index.php?pg-system-catalogs.html

also connect to any database and look at all of the tables / views prefixed
pg_.

hih

steve boyle

"Dempsey Bullock" <dempsey.bullock@impactinnovations.com> wrote in message
news:a0j171$22fu$1@news.tht.net...
> Can some tell me how to query for information in the System Catalog.  I
> don't see where the documentation states which database to use.  I am
using
> WINNT 4.0 w/ version 7.1.3.  Thanks in advance!
>
>