Skip site navigation (1) Skip section navigation (2)

Re: PQputline in BINARY mode?

From: pacquet(at)newsguy(dot)com
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PQputline in BINARY mode?
Date: 2002-08-13 22:15:11
Message-ID: 200208132215.PAA79633@newsguy.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)newsguy(dot)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
>


Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-08-13 22:41:01
Subject: Re: PQputline in BINARY mode?
Previous:From: Tom LaneDate: 2002-08-13 21:53:44
Subject: Re: PQputline in BINARY mode?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group