Re: system catalog views + tables

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/