pg_shseclabel

存储共享数据库对象安全标签的系统表

pg_shseclabel 是一个系统目录表，用于存储共享数据库对象上的安全标签。

pg_shseclabel 在 PostgreSQL 9.2 中添加。

该表在集群的所有数据库之间共享。

按 PostgreSQL 版本定义

pg_shseclabel (PostgreSQL 19)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 18)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 17)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 16)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 15)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 14)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 13)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 12)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 11)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text |           | not null | 
 label    | text |           | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 10)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text |           | not null | 
 label    | text |           | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 9.6)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | not null
 label    | text | not null
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 9.5)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | not null
 label    | text | not null
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 9.4)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 9.3)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

pg_shseclabel (PostgreSQL 9.2)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

文档: pg_shseclabel

变更历史

PostgreSQL 9.5
- 索引 pg_shseclabel_object_index 中 provider 列的定义已更改为使用 text_pattern_ops (提交 0b28ea79)
- 列 provider 和 label 被设置为 NOT NULL (提交 82a532b3)
PostgreSQL 9.2
- 已添加 (提交 463f2625)

参考资料

PostgreSQL 文档： pg_shseclabel

另请参阅

pg_seclabel, SECURITY LABEL

反馈

请将有关 "pg_shseclabel" 的任何评论、建议或更正通过此链接 提交。

版本图表

实用概述

有用链接

咖啡

目录

pg_shseclabel

按 PostgreSQL 版本定义

pg_shseclabel (PostgreSQL 19)

pg_shseclabel (PostgreSQL 18)

pg_shseclabel (PostgreSQL 17)

pg_shseclabel (PostgreSQL 16)

pg_shseclabel (PostgreSQL 15)

pg_shseclabel (PostgreSQL 14)

pg_shseclabel (PostgreSQL 13)

pg_shseclabel (PostgreSQL 12)

pg_shseclabel (PostgreSQL 11)

pg_shseclabel (PostgreSQL 10)

pg_shseclabel (PostgreSQL 9.6)

pg_shseclabel (PostgreSQL 9.5)

pg_shseclabel (PostgreSQL 9.4)

pg_shseclabel (PostgreSQL 9.3)

pg_shseclabel (PostgreSQL 9.2)

变更历史

参考资料

分类

另请参阅

反馈