Hello, Sorry for the previous confusing mail ..
iam in need of a function through which i can get a Relation Node given its name ..
precisely the same one equivalent to " RelationSysNameGetRelation " .. which works for all types of relations (system and user tables)
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:
Iam trying to test for some patch in the code of the Optimizer(planner) and so I need some C functions, which does the job. I think we must have some functions like the ones i have mentioned for the purpose. isin't it ??
regards, -Ramu
select relname from pg_class where oid = 1234;
-- Jonathan Gardner jgardner ( at ) jonathangardner ( dot ) net
_________________________________________________________________
Need a job? Get head-hunted by the best. http://www.naukri.com/msn/index.php?source=hotmail Post your CV free!
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]