On Wed, May 05/08/13, 2013 at 03:38:10PM -0400, Andrew Dunstan wrote:
>
> 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.
You need to first CREATE EXTENSION file_fdw. Then you need to CREATE
SERVER. Then CREATE FOREIGN TABLE. Which requires appropriate permission
to do those things, and certainly has no hope of working on the client
side.
-Ryan P. Kelly