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
