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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
