pg_largeobject_metadata
A system table storing ownership and access privileges for large objects
pg_largeobject_metadata is a system catalogue table storing ownership and access privileges for large objects.
pg_largeobject_metadata was added in PostgreSQL 9.0.
Definition by PostgreSQL version
pg_largeobject_metadata (PostgreSQL 16)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" PRIMARY KEY, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 15)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" PRIMARY KEY, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 14)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" PRIMARY KEY, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 13)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 12)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 11)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 10)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
lomowner | oid | | not null |
lomacl | aclitem[] | | |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.6)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.5)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.4)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.3)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.2)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.1)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
pg_largeobject_metadata (PostgreSQL 9.0)
Table "pg_catalog.pg_largeobject_metadata"
Column | Type | Modifiers
----------+-----------+-----------
lomowner | oid | not null
lomacl | aclitem[] |
Indexes:
"pg_largeobject_metadata_oid_index" UNIQUE, btree (oid)
Documentation: pg_largeobject_metadata
Change history
- PostgreSQL 9.0
- added (commit f1325ce2)
This table has not been modified since it was added in PostgreSQL 9.0.
Examples
postgres=# \lo_import /tmp/hello-world.txt lo_import 16456 postgres=# ALTER LARGE OBJECT 16456 OWNER TO postgres; ALTER LARGE OBJECT postgres=# SELECT * FROM pg_largeobject_metadata; oid | lomowner | lomacl -------+----------+-------- 16456 | 10 | (1 row)
References
- PostgreSQL documentation: pg_largeobject_metadata
