Re: Streaming binary data into db, difference between

Andreas Prohaska wrote:
>
> OK. If I got you right, the Postgres JDBC driver "simulates" the
> java.sql.Blob
> getBinaryStream() etc. methods by using LargeObject internally.
>

Correct.


> I assume that I can use this to read and write Blobs, not to delete them
> since the LargeObject wouldn't be unlinked.
>

Neither to create.  But you can use the org.postgresql.largeobject
extension both to create and to delete (unlink).





--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9