- Table of Contents
- Historical Note
- Inversion Large Objects
- Large Object Interfaces
- Built in registered functions
- Accessing Large Objects from
LIBPQ
- Sample Program
In Postgres, data values are stored in tuples and individual
tuples cannot span data pages. Since the size of a data page is
8192 bytes, the upper limit on the size of a data value is
relatively low. To support the storage of larger atomic values,
Postgres provides a large object interface. This interface provides
file oriented access to user data that has been declared to be a
large type. This section describes the implementation and the
programmatic and query language interfaces to Postgres large object
data.