Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY
Date
Msg-id 50A3EB8B.3040003@gmx.net
Whole thread Raw
In response to Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 11/14/12 11:50 AM, Andrew Dunstan wrote:
>>     COPY table FROM 'some command line |';
>>     COPY table TO '| some command line';
>>
> 
> 
> I'd like to be able to filter STDIN if possible - with this syntax how
> is COPY going to know to hook up STDIN to the program?

Why don't you filter the data before it gets to stdin?  Some program is
feeding the data to "stdin" on the client side.  Why doesn't that do the
filtering?  I don't see a large advantage in having the data be sent
unfiltered to the server and having the server do the filtering.



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Enabling Checksums
Next
From: Andrew Dunstan
Date:
Subject: Re: Enabling Checksums