Le ven. 18 oct. 2019 à 11:51, Patrick FICHE <Patrick.Fiche@xxxxxxxxxxx> a écrit :
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 ?
It's probably easier to create a view on the remote server, and access it as a foreign table on the local server.
