Re: RETURNING syntax for COPY - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: RETURNING syntax for COPY
Date
Msg-id 518AA9A2.4030204@dunslane.net
Whole thread Raw
In response to Re: RETURNING syntax for COPY  (Jim Nasby <jim@nasby.net>)
Responses Re: RETURNING syntax for COPY
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: about index inheritance
Next
From: Ryan Kelly
Date:
Subject: Re: RETURNING syntax for COPY