> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Andreas Pflug
> Sent: 31 May 2006 16:41
> Cc: Tom Lane; pgsql-hackers@postgresql.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.