Re: Possible TODO item: copy to/from pipe - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Possible TODO item: copy to/from pipe
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA3546D@algol.sollentuna.se
Whole thread Raw
In response to Possible TODO item: copy to/from pipe  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Possible TODO item: copy to/from pipe
List pgsql-hackers
> >>>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.
>
> ... as most windows programs are pipe agnostic.

For the record, gzip on win32 works perfectly fine both as a separate
program and running in a pipe. No problem at all. The only issue is that
it's not available by default. (And possible issues with programs
launching it that don't know how to deal with windows style directory
naming)

//Magnus


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Possible TODO item: copy to/from pipe
Next
From: Chris Browne
Date:
Subject: Re: Possible TODO item: copy to/from pipe