pg_largeobject_metadata

A system catalogue 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 (commit f1325ce2).

Definition by PostgreSQL version

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.

Categories

Data type, Large object, System catalogue

See also

pg_largeobject, ALTER LARGE OBJECT