On Wednesday 10 March 2004 09:58 am, Ramanujam H S Iyengar wrote: > Hello, > > How can i get the name of a relation from its Oid ?? I have seen some > functions in utils/cache/relcache.h like RelationIdGetRelation - which > gives Relation Node from Oid RelationSysNameGetRelation - which gives > Relation node for only the System names. > > Can anyone please tell me how to get Relation node from relation name ??? >
Won't you have to go get the data from the database for this? I mean actually execute the query: select relname from pg_class where oid = 1234; -- Jonathan Gardner [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]