Re: Streaming binary data into db, difference between - Mailing list pgsql-jdbc

From Fernando Nasser
Subject Re: Streaming binary data into db, difference between
Date
Msg-id 3F5F2F6E.2070201@redhat.com
Whole thread Raw
In response to Re: Streaming binary data into db, difference between Blob  (Andreas Prohaska <ap@apeiron.de>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Nicolas Modrzyk
Date:
Subject: Re: Streaming binary data into db, difference between Blob
Next
From: Dave Tenny
Date:
Subject: Re: Streaming binary data into db, difference between Blob