Thread: schema of system tables

hello guys,

does somebody know a link to pdf or whatever displaying the schema of
system-tables?
or better has somebody something like this?
i know this is existing for mssql for example, and why not for postgres?
it makes something easier to overview...
i would be thankful to get something like this.

bless
chris

Mit freundlichem Gruß

- Christian Rolle -

--
Büro für praktische Informatik - Kruth & Schröder GbR
Gesellschafter: Alexander Kruth, Jörg Schröder
Philipp-Müller-Straße 12, 23966 Wismar
Tel. 03841/758-1212 Mobil 0160-9107615 Fax 03841/758-1211

Christian Rolle wrote:
> hello guys,
>
> does somebody know a link to pdf or whatever displaying the schema of
> system-tables?
> or better has somebody something like this?

There is an old presentation by Bruce Momjian about it.

http://www.postgresql.org/files/developer/internalpics.pdf
page 64

It's a bit outdated but it is good enough for an introduction.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

On May 10, 2007, at 8:19 , Christian Rolle wrote:

> does somebody know a link to pdf or whatever displaying the schema
> of system-tables?
> or better has somebody something like this?

Have you checked the extensive PostgreSQL documentation?

Chapter 43. System Catalogs
http://www.postgresql.org/docs/8.2/interactive/catalogs.html

Hope this helps.

Michael Glaesemann
grzm seespotcode net