Re: Execute a function through fdw

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 ?