Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get Relation name from Oid ?? - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: How to get Relation name from Oid ??
Date
Msg-id 200402281939.04854.dev@archonet.com
Whole thread Raw
In response to How to get Relation name from Oid ??  ("Ramanujam H S Iyengar" <hals_ramu@hotmail.com>)
List pgsql-hackers
Tree view 
On Saturday 28 February 2004 18:47, Ramanujam H S Iyengar wrote:
> Hello ,
>
> Can somebody please tell me how to get the name of the relation (Attribute
> also) from the Oid and the otherway back (Oid from name) ??

The pg_class table is what you want.

See the system-tables chapter of the manuals for details.

--  Richard Huxton Archonet Ltd

pgsql-hackers by date:

Previous
From: "Ramanujam H S Iyengar"
Date:
Subject: How to get Relation name from Oid ??
Next
From: "Marc G. Fournier"
Date:
Subject: 7.3.6 for Monday ... still a go?