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

[Adrian Klaver]

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