Hello,
Is it possible to execute a function located on a server accessed through Postgres fdw.
This function returns a TABLE structure.
I have mapped rmt_schema and there is a function called Get_Tables in this schema.
I would like to execute something like :
SELECT * FROM rmt_schema.Get_Tables();
Or is it required to create a local function that will access to remote tables in order to achieve the same result ?
Regards,
Patrick Fiche
e. patrick.fiche@aqsacom.com
![](/media/maillist_attaches/pgsql-general/2019/10/18/AM5PR0501MB256343C885DBEE30B96CFAC0EF6C0@AM5PR0501MB2563.eurprd05.prod.outlook.com/image001.png)