Re: bytea encoding - Mailing list pgsql-jdbc

From Jesse
Subject Re: bytea encoding
Date
Msg-id 1115919119.4902.7.camel@weasel
Whole thread Raw
In response to Re: bytea encoding  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: bytea encoding
List pgsql-jdbc
My problem is this:

I want to send a binary file in a CDATA section of an xml file to a
server that will then turn around and put the binary file a bytea
column.

Is there a way that I can use postgresql-74.213.jar (or more recent) to
encode the file in bytea on the client side?  If no, do you know where I
can get code to do that?

If the server puts data in the database will the database recognize that
it is bytea already?

thank you,

Jesse

On Thu, 2005-05-12 at 09:53 +1200, Oliver Jowett wrote:
> Jesse Eichar wrote:
>
> > 1. Is the byte stream (or byte array) converted to bytea on the database
> > side or on client before sending?  (My client is using the
> > postgresql-74.213.jar).
>
> You give the driver a byte[] (setBytes) or InputStream
> (setBinaryStream); it does the rest. Old drivers such as build 213 will,
> IIRC, convert this to a text representation internally before sending to
> the backend; newer drivers will send the data directly without
> conversion. But this is all transparent to the client.
>
> -O


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: ERROR in 8.0 driver, but not 7.4: SELECT DISTINCT, ORDER
Next
From: Josh Berkus
Date:
Subject: Re: [NOVICE] Using PgSQL in high volume and throughput problem