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

From Tom Lane
Subject Re: Execute a function through fdw
Date
Msg-id 29136.1571399679@sss.pgh.pa.us
Whole thread Raw
In response to Re: Execute a function through fdw  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses RE: Execute a function through fdw
Re: Execute a function through fdw
List pgsql-general
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 sort of thing.

            regards, tom lane



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Create role like role
Next
From: Avinash Kumar
Date:
Subject: Re: Postgres Point in time Recovery (PITR),