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

2012/9/13 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:
> Excerpts from Etsuro Fujita's message of jue sep 13 06:13:26 -0300 2012:
>> I'd like to add the following options to the SQL COPY command and the psql \copy
>> instruction:
>>
>> * PREPROCESSOR: Specifies the user-supplied program for COPY IN. The data
>> from an input file is preprocessed by the program before the data is loaded into
>> a postgres table.
>> * POSTPROCESSOR: Specifies the user-supplied program for COPY OUT. The data
>> from a postgres table is postprocessed by the program before the data is stored
>> in an output file.
>
> External programs? I don't like the sound of that; there all kinds of
> open questions, security concerns, and process management problems.
> What if the pre- and postprocessors were functions instead?

+1

this can be solved via pipe and outer processes

Pavel

>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers