System catalog diagram

From: Samuel Thoraval <samuel(dot)thoraval(at)librophyt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: System catalog diagram
Date: 2005-08-02 13:10:20
Message-ID: 42EF70BC.1030401@librophyt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

does anybody have a complete diagram showing the system catalog tables
with their attributes and associations ?
I could only find one for the major system catalogs at
http://www.ninthwonder.com/info/postgres/programmer/extend289.htm .

I find it difficult to find out which pg table holds the information I
need reading through the pg documentation. For instance I currently need
to get the OID for a given namespace in order to query the pg_type
table, and I don't know where to find that information...

Regards,

--
Samuel Thoraval

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2005-08-02 13:11:46 CLUSTER equivalent
Previous Message Jake Stride 2005-08-02 13:07:26 Re: Indexes