Execute a function through fdw - Mailing list pgsql-general

From Patrick FICHE
Subject Execute a function through fdw
Date
Msg-id AM5PR0501MB256343C885DBEE30B96CFAC0EF6C0@AM5PR0501MB2563.eurprd05.prod.outlook.com
Whole thread Raw
Responses Re: Execute a function through fdw
List pgsql-general

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 ?

 

Regards,

 

Patrick Fiche

e. patrick.fiche@aqsacom.com

 

 

Attachment

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Postgres Point in time Recovery (PITR),
Next
From: Sonam Sharma
Date:
Subject: Create role like role