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) ??

thanks
-Ramu

_________________________________________________________________
Masterpieces made affordable! Buy art prints. 
http://go.msnserver.com/IN/42736.asp MSN Shopping.


Sun, 29 Feb 2004 00:17:27 +0530
"Ramanujam H S Iyengar" <hals_ramu@hotmail.com>
How to get Relation name from Oid ??
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

Sat, 28 Feb 2004 19:39:04 +0000
Richard Huxton <dev@archonet.com>
Re: How to get Relation name from Oid ??