On Wed, May 30, 2012 at 5:15 PM, Shigeru HANADA <shigeru.han...@gmail.com> wrote: > Hi Atri, > > (2012/05/30 19:49), Atri Sharma wrote: >> SELECT * FROM table1; >> >> If,for above command,fdw1 is invoked,how do I get the name/Oid of the >> table(i.e. table1) in fdw1? > > For 9.1 and 9.0, you can get foreign table's oid as the first parameter > of PlanForeignScan function. For 9.2, you can get it as the third > parameter of GetForeignRelSize, GetForeignPaths, and GetForeignPlan > functions. In other functions, calling > RelationGetRelid(ForeignScanState->ss.ss_currentRelation) returns the > oid of the foreign table. > > Once you obtained oid of a foreign table, you can get the name of the > foreign table by calling get_rel_name function with the oid, as same as > ordinary tables. > > Regards, > -- > Shigeru HANADA
Thanks a ton Shigeru!!! It is really helpful... -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
