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


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to