↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System catalogs

pg_largeobject

Read the PG 18 manual

The catalog pg_largeobject holds the data making up “large objects”.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

Kind
System catalogs
Columns in this snapshot
3
Definition source
English manual
Metadata snapshot
18.6

Columns 3

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
loidoidNOT NULLIdentifier of the large object that includes this page
pg_largeobject_metadata.oid
pagenoint4NOT NULLPage number of this page within its large object (counting from zero)
databyteaNOT NULLActual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less.
Column history across versions
Version history 5
  1. 9.6 → 10 reworded
  2. 9.4 → 9.5 changed
  3. 8.4 → 9.0 reworded
  4. 8.2 → 8.3 reworded
  5. 8.1 → 8.2 reworded

Definition snapshot: english-manuals:2c8463cb1ca57a759880ca1a760… · English manual source