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 <tgl@xxxxxxxxxxxxx> Sent: Friday, October 18, 2019 1:55 PM To: Guillaume Lelarge <guillaume@xxxxxxxxxxxx> Cc: Patrick FICHE <Patrick.Fiche@xxxxxxxxxxx>; pgsql-generallists.postgresql.org <pgsql-general@xxxxxxxxxxxxxxxxxxxx> Subject: Re: Execute a function through fdw Guillaume Lelarge <guillaume@xxxxxxxxxxxx> writes: > Le ven. 18 oct. 2019 à 11:51, Patrick FICHE > <Patrick.Fiche@xxxxxxxxxxx> 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
