Re: System catalog diagram

Reading through "Chapter 41. System Catalogs" down to sub chapter
"pg_type" I could actually easily get the namespace's OID from table
pg_namespce: pg_namespace
<http://www.postgresql.org/docs/8.0/interactive/catalog-pg-namespace.html>.oid.

So sorry, may be reading through the documentation is good enough and
not so difficult :-[ ...

Samuel Thoraval a écrit :

>
> 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
LIBROPHYT, Bioinformatique
Centre de Cadarache
Bâtiment 185, DEVM
13108 St Paul-Lez-Durance
France
Tél: +33 442 574 799
Fax: +33 442 574 439
e-mail : samuel(dot)thoraval(at)librophyt(dot)com