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

From Guillaume Lelarge
Subject Re: Execute a function through fdw
Date
Msg-id CAECtzeUbE=4_Y1Am75j6+em75LxFE69t=Zazp5_bpjGjcoV+ig@mail.gmail.com
Whole thread Raw
In response to Execute a function through fdw  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
Responses Re: Execute a function through fdw
List pgsql-general
Le ven. 18 oct. 2019 à 11:51, Patrick FICHE <Patrick.Fiche@aqsacom.com> a écrit :

Hello,

 

Is it possible to execute a function located on a server accessed through Postgres fdw.

This function returns a TABLE structure.

 

I have mapped rmt_schema and there is a function called Get_Tables in this schema.

I would like to execute something like :

SELECT * FROM rmt_schema.Get_Tables();

 

Or is it required to create a local function that will access to remote tables in order to achieve the same result ?


It's probably easier to create a view on the remote server, and access it as a foreign table on the local server.

pgsql-general by date:

Previous
From: Sonam Sharma
Date:
Subject: Create role like role
Next
From: Luca Ferrari
Date:
Subject: Re: stable for each row before insert trigger