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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match