From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Wed, 31 May 2006 12:30:07 -0400
Message-ID: <13208.1149093007@sss.pgh.pa.us> (raw)
In-Reply-To: <447DB910.2020607@pse-consulting.de>
References: <12436.1149087794@sss.pgh.pa.us>
<447DB844.6010507@pse-consulting.de>
<447DB910.2020607@pse-consulting.de>
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> 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.
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.
regards, tom lane
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: tgl@sss.pgh.pa.us, pgadmin@pse-consulting.de
Subject: Re: Possible TODO item: copy to/from pipe
In-Reply-To: <13208.1149093007@sss.pgh.pa.us>
* 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