Re: How to get Relation name from Oid ??

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

In response to

Responses

Browse pgsql-hackers by date

  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