Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Possible TODO item: copy to/from pipe



> >>>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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group