Le ven. 18 oct. 2019 à 11:51, Patrick FICHE <patrick.fi...@aqsacom.com> 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. >
