pg_largeobject

A system catalogue table containing large object data

pg_largeobject is a system catalogue table containing large object data.

pg_largeobject was added in PostgreSQL 7.1 (commit cf5a950c).

psql commands

\dl or \lo_list list available large objects.

Definition by PostgreSQL version

pg_largeobject (PostgreSQL 13)

         Table "pg_catalog.pg_largeobject"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 loid   | oid     |           | not null |
 pageno | integer |           | not null |
 data   | bytea   |           | not null |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 12)

         Table "pg_catalog.pg_largeobject"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 loid   | oid     |           | not null |
 pageno | integer |           | not null |
 data   | bytea   |           | not null |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 11)

         Table "pg_catalog.pg_largeobject"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 loid   | oid     |           | not null |
 pageno | integer |           | not null |
 data   | bytea   |           | not null |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 10)

         Table "pg_catalog.pg_largeobject"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 loid   | oid     |           | not null |
 pageno | integer |           | not null |
 data   | bytea   |           | not null |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.6)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   | not null
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.5)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   | not null
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.4)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.3)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.2)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.1)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 9.0)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 8.4)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 8.3)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

pg_largeobject (PostgreSQL 8.2)

Table "pg_catalog.pg_largeobject"
 Column |  Type   | Modifiers
--------+---------+-----------
 loid   | oid     | not null
 pageno | integer | not null
 data   | bytea   |
Indexes:
    "pg_largeobject_loid_pn_index" UNIQUE, btree (loid, pageno)
    

Documentation: pg_largeobject

Change history

This table has not been modified since it was added in PostgreSQL 7.1.

Categories

Data type, Large object, Storage, System catalogue

See also

pg_largeobject_metadata