pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsystem catalog views + tables
4+ messages / 4 participants
[nested] [flat]
* system catalog views + tables
@ 2008-10-28 20:11 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-10-28 20:17 ` Re: system catalog views + tables Joshua Drake <jd@commandprompt.com>
2008-10-30 08:52 ` Re: system catalog views + tables damien clochard <damien@dalibo.info>
0 siblings, 2 replies; 4+ messages in thread
From: Isabella Ghiurea @ 2008-10-28 20:11 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: system catalog views + tables
2008-10-28 20:11 system catalog views + tables Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2008-10-28 20:17 ` Joshua Drake <jd@commandprompt.com>
1 sibling, 0 replies; 4+ messages in thread
From: Joshua Drake @ 2008-10-28 20:17 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: 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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: system catalog views + tables
2008-10-28 20:11 system catalog views + tables Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2008-10-30 08:52 ` damien clochard <damien@dalibo.info>
2008-10-30 16:08 ` Re: system catalog views + tables Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 1 reply; 4+ messages in thread
From: damien clochard @ 2008-10-30 08:52 UTC (permalink / raw)
To: pgsql-admin; +Cc: isabella.ghiurea@nrc-cnrc.gc.ca
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: system catalog views + tables
2008-10-28 20:11 system catalog views + tables Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-10-30 08:52 ` Re: system catalog views + tables damien clochard <damien@dalibo.info>
@ 2008-10-30 16:08 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2008-10-30 16:08 UTC (permalink / raw)
To: damien clochard <damien@dalibo.info>; +Cc: pgsql-admin; isabella.ghiurea@nrc-cnrc.gc.ca
damien clochard wrote:
> 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
Thanks -- I've added this to the Developer's FAQ
http://wiki.postgresql.org/wiki/Developer_FAQ#Is_there_a_diagram_of_the_system_catalogs_available.3F
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-10-30 16:08 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-28 20:11 system catalog views + tables Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-10-28 20:17 ` Joshua Drake <jd@commandprompt.com>
2008-10-30 08:52 ` damien clochard <damien@dalibo.info>
2008-10-30 16:08 ` Alvaro Herrera <alvherre@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox