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 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

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)

Categories

Data type, Large object, System catalogue

See also

pg_largeobject, ALTER LARGE OBJECT