Re: [HACKERS] How to get Relation name from Oid ??

2004-03-09 Thread Tom Lane
"Tom Hebbron" <[EMAIL PROTECTED]> writes: > If you need to use the path returned from the regclass cast as text, you > will need to create a cast from regclass to text - this can be achieved > using the following functions - making use of the cstring type that the > return/input functions for these

Re: [HACKERS] How to get Relation name from Oid ??

2004-03-09 Thread Tom Hebbron
"Jonathan Gardner" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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

Re: [HACKERS] How to get Relation name from Oid ??

2004-03-01 Thread Jonathan Gardner
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 documenta

[HACKERS] How to get Relation name from Oid ??

2004-02-28 Thread Halasipuram seshadri ramanujam
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 = " Karyathuranaam na Sukham na Nidhra " www.it.iitb.ac.in/~ramu __

Re: [HACKERS] How to get Relation name from Oid ??

2004-02-28 Thread Richard Huxton
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

[HACKERS] How to get Relation name from Oid ??

2004-02-28 Thread Ramanujam H S Iyengar
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/