Thread: BYTEA transport

I have been trying to figure out how BYTEA goes across the wire from the
backend to the front. It is not clear to me whether they transit in
their huge ASCII format, or in a binary format. Sending an object across
this wire in ASCII would (a) fluff it by a couple of factors and (b) lay
a string-i-fication overhead on the server and parse-i-fication overhead
on the client. I see some 'binaryCursor' booleans in the driver, but am
not sure how to use binary cursors in the context of a JDBC connection.

Any clarification on how to do binary transport using JDBC?

Thanks,
Paul

--
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey@refractions.net
     | Phone: (250) 885-0632
     \_

Paul,

See the other emails on the list today that discussed this same topic.

thanks,
--Barry

Paul Ramsey wrote:

>I have been trying to figure out how BYTEA goes across the wire from the
>backend to the front. It is not clear to me whether they transit in
>their huge ASCII format, or in a binary format. Sending an object across
>this wire in ASCII would (a) fluff it by a couple of factors and (b) lay
>a string-i-fication overhead on the server and parse-i-fication overhead
>on the client. I see some 'binaryCursor' booleans in the driver, but am
>not sure how to use binary cursors in the context of a JDBC connection.
>
>Any clarification on how to do binary transport using JDBC?
>
>Thanks,
>Paul
>
>
>