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