> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Pflug
> Sent: 31 May 2006 16:41
> Cc: Tom Lane; [email protected]
> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
