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

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, pgsql-hackers@postgresql.org
Date: 2012-09-13T17:26:49Z
Lists: pgsql-hackers
On 09/13/2012 01:20 PM, Dimitri Fontaine wrote:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> I think it would be a lot better if this were designed so that the
>> processor programs executed on client side.  Which would probably make
>> it not a COPY patch at all, but something in psql.
> And pgloader, which already has a part of that feature with the per
> column reformating facility.
>

Yeah, I'd be inclined to say that pre/post processing of this kind is 
really a job for specialized clients.

cheers

andrew