pg_largeobject
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 16)
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 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
data
set 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