Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] binary insert with JDBC

From: Peter Mount <peter(at)maidstone(dot)gov(dot)uk>
To: "'Sean Reilly'" <sreilly(at)cnri(dot)reston(dot)va(dot)us>, "'interfaces postgres'" <pgsql-interfaces(at)postgresql(dot)org>
Cc: "'Peter at home'" <peter(at)retep(dot)org(dot)uk>
Subject: RE: [INTERFACES] binary insert with JDBC
Date: 1998-05-12 15:20:23
Message-ID: 714F8949628ED1119E0F0060082C52F5095246@vesta.maidstone.gov.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)maidstone(dot)gov(dot)uk, peter(at)retep(dot)org(dot)uk
Please note that this is from my works email. If you reply, please cc my
home address.



-----Original Message-----
From: owner-pgsql-interfaces(at)hub(dot)org
[mailto:owner-pgsql-interfaces(at)hub(dot)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


Responses

pgsql-interfaces by date

Next:From: Ewan MellorDate: 1998-05-12 16:08:58
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Previous:From: Hannu KrosingDate: 1998-05-12 14:53:05
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group