On Tue, 28 Oct 2008 13:11:38 -0700 Isabella Ghiurea <isabella.ghiurea@xxxxxxxxxxxxxx> 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/ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin