Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY

On 14 November 2012 15:09, Fujii Masao <masao.fujii@gmail.com> wrote:

> What about further extending the COPY IN syntax to the following?
>
>     COPY table_name FROM 'progname [ option, ... ]' WITH ...
>
> I'd just like to execute
>
>     COPY vmstat_table FROM 'vmstat' WITH ...

If we go ahead with this, I think it needs additional keyword to
indicate that we will execute the file rather than read from it. I
don't think we should rely on whether the file is executable or not to
determine how we should treat it.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services