Thanks a lot for your answer.
Using a view is really a good solution for my case.
As I already use fdw for some other cases, I prefer not to mix with dblink.
Regards,
Patrick Fiche
-----Original Message-----
From: Tom Lane <t...@sss.pgh.pa.us>
Sent: Friday, October 18, 2019 1:55 PM
To: Guillaume Lelarge <guilla...@lelarge.info>
Cc: Patrick FICHE <patrick.fi...@aqsacom.com>;
pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Execute a function through fdw
Guillaume Lelarge <guilla...@lelarge.info> writes:
> Le ven. 18 oct. 2019 à 11:51, Patrick FICHE
> <patrick.fi...@aqsacom.com> a écrit :
>> Is it possible to execute a function located on a server accessed
>> through Postgres fdw.
> It's probably easier to create a view on the remote server, and access
> it as a foreign table on the local server.
Yeah. Or if you really want to call a remote function by name, see dblink.
postgres_fdw actively avoids doing that sort of thing.
regards, tom lane
