pg_largeobject
A system table containing large object data
pg_largeobject is a system catalogue table containing large object (LO) data.
pg_largeobject was added in PostgreSQL 7.1.
psql commands
\dl or \lo_list list available large objects.
Definition by PostgreSQL version
pg_largeobject (PostgreSQL 15)
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" PRIMARY KEY, btree (loid, pageno)
Documentation: pg_largeobject
pg_largeobject (PostgreSQL 14)
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" PRIMARY KEY, btree (loid, pageno)
Documentation: pg_largeobject
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
- PostgreSQL 9.5
- column
dataset toNOT NULL(commit 82a532b3)
- column
- PostgreSQL 7.1
- added (commit cf5a950c)
Examples
Basic usage of pg_largeobject (using psql's large object slash commands):
postgres=# SELECT * FROM pg_largeobject; loid | pageno | data ------+--------+------ (0 rows) postgres=# \lo_import /tmp/hello-world.txt lo_import 16455 postgres=# SELECT * FROM pg_largeobject; loid | pageno | data -------+--------+------------------------------ 16455 | 0 | \x48656c6c6f20776f726c64210a (1 row) postgres=# \lo_unlink 16455 lo_unlink 16455 postgres=# SELECT * FROM pg_largeobject; loid | pageno | data ------+--------+------ (0 rows)
References
- PostgreSQL documentation: pg_largeobject