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

From damien clochard
Subject Re: system catalog views + tables
Date
Msg-id 490975C2.2090702@dalibo.info
Whole thread Raw
In response to system catalog views + tables  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
Responses Re: system catalog views + tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Isabella Ghiurea a écrit :
> 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

Hi !

Here's a poster of PostgreSQL 8.3 internal catalogs
http://dalibo.org/_media/articles/catalog.png?cache=cache

SVG version is available here :
http://svn.postgresql.fr/repos/materials/advocacy/trunk/posters/catalogs83.svg

Hope this helps...

--
damien clochard
http://dalibo.org | http://dalibo.com



pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: 8.3.4 PITR recovery questions
Next
From: Jaume Sabater
Date:
Subject: Deleting old archived WAL files