目录

pg_largeobject_metadata

存储大对象的所有权和访问权限的系统表

pg_largeobject_metadata 是一个 系统目录 表，用于存储 大对象 的所有权和访问权限。

pg_largeobject_metadata 在 PostgreSQL 9.0 中被添加。

按 PostgreSQL 版本定义

pg_largeobject_metadata (PostgreSQL 19)

      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)

文档: pg_largeobject_metadata

pg_largeobject_metadata (PostgreSQL 18)

      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)

文档: pg_largeobject_metadata

pg_largeobject_metadata (PostgreSQL 17)

      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)

文档: pg_largeobject_metadata

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_largeobject_metadata

变更历史

自 PostgreSQL 9.0 添加以来，此表未被修改。

示例

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)

分类

数据类型, 大对象, 系统目录

另请参阅

pg_largeobject, ALTER LARGE OBJECT

反馈

有关“pg_largeobject_metadata”的任何评论、建议或更正，请 在此 提交。