Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D386247591C for ; Tue, 13 Aug 2002 17:54:00 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 0E48D4758BB for ; Tue, 13 Aug 2002 17:54:00 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g7DLrjVk001624; Tue, 13 Aug 2002 17:53:45 -0400 (EDT) To: pacquet@newsguy.com Cc: pgsql-interfaces@postgresql.org Subject: Re: PQputline in BINARY mode? In-reply-to: <200208132141.OAA71833@newsguy.com> References: <200208132141.OAA71833@newsguy.com> Comments: In-reply-to pacquet@newsguy.com message dated "Tue, 13 Aug 2002 14:41:36 -0700" Date: Tue, 13 Aug 2002 17:53:44 -0400 Message-ID: <1623.1029275624@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/38 X-Sequence-Number: 3000 pacquet@newsguy.com writes: > the question is, can I combine both techniques, and use a programmatic > interface to copy binary information? Nope. There's no support for binary COPY in the frontend/backend protocol. This is one of the things I'd like to see fixed next time we change the protocol. (That's a sufficiently painful thing that we don't do it often --- the last time was release 6.4 --- but we're considering a protocol rev for the next development cycle, 7.4.) regards, tom lane