On 05/08/2013 03:23 PM, Jim Nasby wrote:
>> WITH new_data AS (
>> COPY FROM ...
>> RETURNING id, field_to_check
>> )
>
Why is this better than this, which you can do today?
WITH new_data AS ( INSERT into ... FROM foreign_table_with_file_fdw RETURNING ... )
The whole reason I abandoned trying to do this sort of thing with COPY
was that I realized the FDW would provide what I wanted.
cheers
andrew