| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | Halasipuram seshadri ramanujam <hals_ramu(at)yahoo(dot)co(dot)in> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: How to get Relation name from Oid ?? |
| Date: | 2004-03-01 18:39:18 |
| Message-ID: | 200403011039.18227.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)jonathangardner(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-03-01 18:39:29 | Re: Foreign key type checking patch |
| Previous Message | Fabien COELHO | 2004-03-01 18:36:20 | Re: Foreign key type checking patch |