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 533A49FA43C for ; Sun, 4 Jun 2006 09:07:47 -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 05663-09 for ; Sun, 4 Jun 2006 09:07:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by postgresql.org (Postfix) with ESMTP id 5AF3E9F9DB0 for ; Sun, 4 Jun 2006 09:07:38 -0300 (ADT) Received: from [84.143.8.55] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de (node=mrelayeu2) with ESMTP (Nemesis), id 0MKwtQ-1FmrOI0qYp-0000aY; Sun, 04 Jun 2006 14:07:34 +0200 Received: from p548f0837.dip0.t-ipconnect.de ([84.143.8.55] helo=[192.168.0.100]) by pse.dyndns.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1FmrOG-0008Df-KJ; Sun, 04 Jun 2006 14:07:32 +0200 Message-ID: <4482CCE5.6020900@pse-consulting.de> Date: Sun, 04 Jun 2006 14:07:01 +0200 From: Andreas Pflug User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Bruce Momjian CC: Tom Lane , pgsql-hackers@postgresql.org Subject: Re: Possible TODO item: copy to/from pipe References: <200606040012.k540C5V29587@candle.pha.pa.us> In-Reply-To: <200606040012.k540C5V29587@candle.pha.pa.us> 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: 200606/138 X-Sequence-Number: 84371 Bruce Momjian wrote: > > For use case, consider this: > > COPY mytable TO '| rsh x@y.com > test '; > > so you can COPY to another server directly. > Why not rsh psql -c "\copy foobar to test" ? Regards, Andreas