内容

pg_largeobject_metadata

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

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

pg_largeobject_metadata是在PostgreSQL 9.0中添加的。

按PostgreSQL版本定义

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"的评论、建议或更正 在此。