Skip site navigation (1) Skip section navigation (2)

Re: system catalog views + tables

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: system catalog views + tables
Date: 2008-10-28 20:17:12
Message-ID: 20081028131712.4279a4c9@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 28 Oct 2008 13:11:38 -0700
Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:

> Hello,
> How can I see all system catalog tables and views , I'm in potsgres
> db ( using PG 8.3).
> Is there a way to have /get a full list and description of  system  
> tables and views  in kind of  hard copy format, same as Oracle or
> RDBMS posters for system catalogs objects?
> thank you,
> Isabella
> 

The documentation?

http://www.postgresql.org/docs/8.3/static/information-schema.html

If you are in psql you can also do:

\d pg_ <tab> <tab>

Joshua D. Drake

-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/



In response to

pgsql-admin by date

Next:From: Marc FrommDate: 2008-10-29 15:40:21
Subject: drop role fails
Previous:From: Isabella GhiureaDate: 2008-10-28 20:11:38
Subject: system catalog views + tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group