Horton
Menu

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

Craig Ringer <ringerc@ringerc.id.au>

View thread
From: Craig Ringer <ringerc@ringerc.id.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, pgsql-hackers@postgresql.org
Date: 2012-09-18T07:07:05Z
Lists: pgsql-hackers 
On 09/13/2012 10:25 PM, Tom Lane wrote:
> 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.

Either that, or allow the pre- and post- processors to be programs 
written in a (possibly trusted) PL.

I can't say I really see the point though, when it's easy to just filter 
the csv through a pipeline.

--
Craig Ringer