Date: Tue, 13 Aug 2002 15:15:11 -0700 (PDT)
Message-Id: <200208132215.PAA79633@newsguy.com>
To: tgl@sss.pgh.pa.us, pgsql-interfaces@postgresql.org
From: pacquet@newsguy.com
Subject: Re: PQputline in BINARY mode? 

Thanks.  Now I realize what should have been obvious:  the command "COPY
BINARY" is being executed by the backend, while PQputline() is a frontend
routine. Duh.

However, this is an embedded system, so some modest amount of backend-hacking
is quite acceptable if the payoff is large enough. Do you have any pointers on
implementing a variant of COPY BINARY <> FROM file that works out of memory
instead of a file?


At Tue, 13 Aug 2002 17:53:44 -0400, you wrote
>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
>