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

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@aklaver.com