BYTEA transport

From: Paul Ramsey <pramsey(at)refractions(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: BYTEA transport
Date: 2002-07-05 19:37:48
Message-ID: 3D25F58C.8F999140@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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(at)refractions(dot)net
| Phone: (250) 885-0632
\_

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Garnier 2002-07-05 21:24:40 Re: Retrieving binary data
Previous Message Barry Lind 2002-07-05 19:12:45 Re: Retrieving binary data