Re: Execute a function through fdw

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Execute a function through fdw
Дата
Msg-id 29136.1571399679@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Execute a function through fdw  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы RE: Execute a function through fdw  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
Re: Execute a function through fdw  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Create role like role
Следующее
От: Avinash Kumar
Дата:
Сообщение: Re: Postgres Point in time Recovery (PITR),