Re: Wire protocol: type-specific opt-in to binary format - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Wire protocol: type-specific opt-in to binary format
Date
Msg-id 82bos1bort.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Wire protocol: type-specific opt-in to binary format  (Florian Pflug <fgp@phlo.org>)
Responses Re: Wire protocol: type-specific opt-in to binary format
List pgsql-hackers
* Florian Pflug:

> On Nov24, 2011, at 10:03 , Florian Weimer wrote:
>> I would like to add functionality which allows a client to tell the
>> server which types can be sent in binary format.  The immediate goal is
>> to suppress hex quoting for BYTEA values, but it seems to make sense to
>> make this functionality more general.
>
> If you use the extended query protocol, the client can already choose
> text vs. binary representation on a per-column basis. You can query
> the result's column types by issuing a Describe message after the
> Parse message.  For each column you can then decide whether you want
> textual or binary representation, and include that choice in the
> subsequent Bind message.

Interesting.  Doesn't this introduce another roundtrip?

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Notes on implementing URI syntax for libpq
Next
From: Florian Weimer
Date:
Subject: Re: Notes on implementing URI syntax for libpq