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 <[email protected]> Sent: Friday, October 18, 2019 1:55 PM To: Guillaume Lelarge <[email protected]> Cc: Patrick FICHE <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> Subject: Re: Execute a function through fdw Guillaume Lelarge <[email protected]> writes: > Le ven. 18 oct. 2019 à 11:51, Patrick FICHE > <[email protected]> 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
