目录

pg_seclabel

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

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

pg_seclabel 于 PostgreSQL 9.1 中添加。

按 PostgreSQL 版本定义

pg_seclabel (PostgreSQL 19)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 18)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 17)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 16)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 15)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 14)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 13)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 12)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    | C         | not null | 
 label    | text    | C         | not null | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 11)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    |           | not null | 
 label    | text    |           | not null | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)

文档: pg_seclabel

pg_seclabel (PostgreSQL 10)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default 
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null | 
 classoid | oid     |           | not null | 
 objsubid | integer |           | not null | 
 provider | text    |           | not null | 
 label    | text    |           | not null | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.6)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | not null
 label    | text    | not null
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.5)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | not null
 label    | text    | not null
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.4)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | 
 label    | text    | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.3)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | 
 label    | text    | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.2)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | 
 label    | text    | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

pg_seclabel (PostgreSQL 9.1)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers 
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | 
 label    | text    | 
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)

文档: pg_seclabel

变更历史

分类

安全, 系统目录

另请参阅

pg_seclabels, pg_shseclabel, SECURITY LABEL

反馈

请在此处提交关于“pg_seclabel”的任何评论、建议或更正 此处。