> OP:
>> I thought about using dblink and the EXCEPT query, but then I need to know the field list of each query result, which is a pain in the butt.
> That is not correct. As long as the table definitions are precisely
> the same, you can move records across dblink without specifying
> fields. You do this by using record type for the composite which
> dblink sends across as text.
>
> merlin
Do you have a quick example? This is what I have tried:
select * from tbla
except
select * from dblink('host=dbhost dbname=otherdb user=myuser
password=mypwd'::text, 'select * from tbla')
The error I get back is:
ERROR: a column definition list is required for functions returning
"record"
Sim