How to get Relation name from Oid ??

Started by Ramanujam H S Iyengaralmost 22 years ago2 messages
#1Ramanujam H S Iyengar
hals_ramu@hotmail.com

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.

#2Richard Huxton
dev@archonet.com
In reply to: Ramanujam H S Iyengar (#1)
Re: 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