Re: Wire protocol: type-specific opt-in to binary format

From: Florian Pflug <fgp(at)phlo(dot)org>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Wire protocol: type-specific opt-in to binary format
Date: 2011-11-24 13:59:43
Message-ID: 28FEC0D9-8B0E-4B27-9A49-91DF18BA61A6@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

best regards,
Florian Pflug

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-11-24 14:01:58 Re: Notes on implementing URI syntax for libpq
Previous Message Simon Riggs 2011-11-24 13:59:23 Re: bug of recovery?