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
>