Re: Error: "remote query result rowtype does not match the specified FROM clause rowtype," on remote function call

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 3/25/19 3:26 PM, Adrian Klaver wrote:
> On 3/25/19 3:20 PM, Antonio Gomez wrote:

> select * from public._test1();
> ERROR:  a column definition list is required for functions returning 
> "record"
> LINE 1: select * from public._test1();
>
> Have you looked at postresql_fdw?:

Sorry was not thinking. postgresql_fdw works on tables/views, it would 
not help in your situation.

> https://www.postgresql.org/docs/11/postgres-fdw.html
>
> > Thanks for your response!

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx