Re: system catalog views + tables - Mailing list pgsql-admin

From Joshua Drake
Subject Re: system catalog views + tables
Date
Msg-id 20081028131712.4279a4c9@jd-laptop
Whole thread Raw
In response to system catalog views + tables  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
On Tue, 28 Oct 2008 13:11:38 -0700
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.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/



pgsql-admin by date:

Previous
From: Isabella Ghiurea
Date:
Subject: system catalog views + tables
Next
From: Marc Fromm
Date:
Subject: drop role fails