Re: jdbc lob and postgresql

Anu Padki wrote on 12.12.2007 20:09:
> Hello all,
>
> I am contemplating to use postgresql for a product that requires to
> manipulate many blobs.
> From the documentation I am not clear if one has to use postgres api to
> insert/update/select blobs or one can use standard jdbc api?
> Can I just execute a statement insert into (..) that has a blob and do a
> getBlob to retrieve it?

Using a PreparedStatement with setBinaryStream() to insert the blob and
getBinaryStream() to read the BLOB works fine for me.

Thomas