Ok, which version of Postgres are you using?
To use Blobs (Binary Large Objects) currently you need to use the oid type.
Take a look at the example.blobtest and example.ImageViewer classes as these
deal with Blobs.
--
Peter T Mount, peter@maidstone.gov.uk, peter@retep.org.uk
Please note that this is from my works email. If you reply, please cc my
home address.
-----Original Message-----
From: owner-pgsql-interfaces@hub.org
[mailto:owner-pgsql-interfaces@hub.org]On Behalf Of Sean Reilly
Sent: Monday, May 11, 1998 11:09 PM
To: interfaces postgres
Subject: [INTERFACES] binary insert with JDBC
Can anyone tell me how to insert binary data into
a postgres table using JDBC? What type field should I use?
Most importantly, how do I create an SQL statement with
binary data? I thought this could be done with a
PreparedStatement and setBytes() but it doesn't seem to
be implemented in postgres.PreparedStatement. Is there
some way to encode the binary value into the SQL string
(like hex encoding or something)?
I looked through the docs but couldn't find anything
related to this, but it seems like it might be a common
problem.
Thanks,
Sean