Large objects are supported in the standard JDBC specification. However, that interface is limited, and the API provided by LightDB allows for random access to the objects contents, as if it was a local file.
The org.postgresql.largeobject package provides to Java the libpq C
interface's large object API. It consists of two classes,
LargeObjectManager
, which deals with creating, opening and
deleting large objects, and LargeObject
which deals with an
individual object. For an example usage of this API, please see Example 7.1, "Processing
Binary Data in JDBC".