X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 57D709FA5F0 for ; Wed, 31 May 2006 12:41:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61820-06 for ; Wed, 31 May 2006 12:41:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.188]) by postgresql.org (Postfix) with ESMTP id 7D7E09FA5DD for ; Wed, 31 May 2006 12:41:06 -0300 (ADT) Received: from [84.143.7.134] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis), id 0ML2ov-1FlSoj2RyR-0003L6; Wed, 31 May 2006 17:41:05 +0200 Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44) id 1FlSoi-0004ph-Gg; Wed, 31 May 2006 17:41:04 +0200 Message-ID: <447DB910.2020607@pse-consulting.de> Date: Wed, 31 May 2006 17:41:04 +0200 From: Andreas Pflug User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 CC: Tom Lane , pgsql-hackers@postgreSQL.org Subject: Re: Possible TODO item: copy to/from pipe References: <12436.1149087794@sss.pgh.pa.us> <447DB844.6010507@pse-consulting.de> In-Reply-To: <447DB844.6010507@pse-consulting.de> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de login:0ce7ee5c3478b8d72edd8e05ccd40b70 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1331 X-Sequence-Number: 84196 Andreas Pflug wrote: > > 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. Regards, Andreas