RE: Execute a function through fdw - Mailing list pgsql-general

From Patrick FICHE
Subject RE: Execute a function through fdw
Date
Msg-id AM5PR0501MB2563835978247A1345CF001AEF6C0@AM5PR0501MB2563.eurprd05.prod.outlook.com
Whole thread Raw
In response to Re: Execute a function through fdw  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: Execute a function through fdw
List pgsql-general
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@sss.pgh.pa.us> 
Sent: Friday, October 18, 2019 1:55 PM
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Patrick FICHE <Patrick.Fiche@aqsacom.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Execute a function through fdw

Guillaume Lelarge <guillaume@lelarge.info> writes:
> Le ven. 18 oct. 2019 à 11:51, Patrick FICHE 
> <Patrick.Fiche@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
sortof thing.
 

            regards, tom lane

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: DBD::Pg exorts char columns with trailing blanks
Next
From: Jeremy Smith
Date:
Subject: Visibility Map Issues