Re: How to get Relation name from Oid ??

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Ramanujam H S Iyengar" <hals_ramu(at)hotmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to get Relation name from Oid ??
Date: 2004-02-28 19:39:04
Message-ID: 200402281939.04854.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2004-02-28 19:50:22 7.3.6 for Monday ... still a go?
Previous Message Richard Huxton 2004-02-28 19:37:26 Re: WAL Optimisation - configuration and usage