Re: Possible TODO item: copy to/from pipe

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org 
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Andreas Pflug
> Sent: 31 May 2006 16:41
> Cc: Tom Lane; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Possible TODO item: copy to/from pipe
> 
> Andreas Pflug wrote:
> 
> > 
> > Won't help too much, until gzip's output is piped back too, so a 
> > replacement for COPY .. TO STDOUT COMPRESSED  would be
> > COPY ... TO '| /bin/gzip |' STDOUT, to enable clients to 
> receive the 
> > reduced stuff.
> 
> Forgot to mention:
> COPY COMPRESSED was also meant to introduce a portable format that's 
> efficient for both text and binary data. Relying on some 
> external XYZzip 
> version seems not too portable to me.

It does have that advantage. Gzip and others are not particularly
Windows friendly for example.

Regards, Dave.