From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Wed, 31 May 2006 19:26:47 +0200
Message-ID: <447DD1D7.20001@pse-consulting.de> (raw)
In-Reply-To: <447DCFAF.4070308@commandprompt.com>
References: <12436.1149087794@sss.pgh.pa.us>
<447DB844.6010507@pse-consulting.de>
<447DB910.2020607@pse-consulting.de>
<13208.1149093007@sss.pgh.pa.us>
<447DCFAF.4070308@commandprompt.com>
Joshua D. Drake wrote:
>>
>> 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.
What about all other client tools?
My COPY WITH COMPRESSION is not the same as taking a copy file and
zipping it; it creates a copy file with BinarySignature that has
compressed bytes in the data part, thus it can be handled by any client
app that can stream binary copy files from/to the server.
Regards,
Andreas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pgadmin@pse-consulting.de, jd@commandprompt.com, tgl@sss.pgh.pa.us
Subject: Re: Possible TODO item: copy to/from pipe
In-Reply-To: <447DD1D7.20001@pse-consulting.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox