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/