>
> I dislike putting this into the backend precisely because it's trying to
> impose a one-size-fits-all compression solution. Someone might wish to
> use bzip2 instead of gzip, for instance, or tweak the compression level
> options of gzip. It's trivial for the user to do that if the
> compression program is separate, not trivial at all if it's wired into
> COPY. Also, a pipe feature would have uses unrelated to compression,
> such as on-the-fly analysis or generation of data.
It seems that it would be better to have the options within pg_dump
which would give the most flexibility.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL
solutionssince 1997 http://www.commandprompt.com/