On Fri, Oct 18, 2019 at 7:55 AM Tom Lane wrote:
> Guillaume Lelarge writes:
> > Le ven. 18 oct. 2019 à 11:51, Patrick FICHE
> 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 remo
Le ven. 18 oct. 2019 à 17:53, Patrick FICHE
mailto:patrick.fi...@aqsacom.com>> a écrit :
Hi,
I got one more issue after I created my view.
I created it on my Server 1 but I am unable to view it on the Server 2.
I can see all tables through fdw after IMPORT FOREIGN SCHEMA.
I was able to get acce
Le ven. 18 oct. 2019 à 17:53, Patrick FICHE a
écrit :
> Hi,
>
> I got one more issue after I created my view.
>
> I created it on my Server 1 but I am unable to view it on the Server 2.
> I can see all tables through fdw after IMPORT FOREIGN SCHEMA.
>
> I was able to get access to my view only af
Lelarge
Cc: pgsql-generallists.postgresql.org
Subject: RE: Execute a function through fdw
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
: Patrick FICHE ;
pgsql-generallists.postgresql.org
Subject: Re: Execute a function through fdw
Guillaume Lelarge writes:
> Le ven. 18 oct. 2019 à 11:51, Patrick FICHE
> a écrit :
>> Is it possible to execute a function located on a server accessed
>> through Postgres fdw.
>
Guillaume Lelarge writes:
> Le ven. 18 oct. 2019 à 11:51, Patrick FICHE 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.
Le ven. 18 oct. 2019 à 11:51, Patrick FICHE 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
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
