Request a Demo
Home   >   mailing lists

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

From Jonathan Gardner
Subject Re: How to get Relation name from Oid ??
Date
Msg-id 200403011039.18227.jgardner@jonathangardner.net
Whole thread Raw
In response to How to get Relation name from Oid ??  (Halasipuram seshadri ramanujam<hals_ramu@yahoo.co.in>)
List pgsql-hackers
Tree view 
On Friday 27 February 2004 12:01 pm, Halasipuram seshadri ramanujam 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) ??
>

There is a document on the system tables in the PostgreSQL documentation.

http://www.postgresql.org/docs/7.4/static/catalogs.html

pg_class is the relation you are looking for.

-- 
Jonathan Gardner
jgardner@jonathangardner.net

pgsql-hackers by date:

Previous
From: larryr@saturn.sdsu.edu
Date:
Subject: Hey, ya! =))
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Hey, ya! =))