目录

pg_seclabel

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

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

pg_seclabel 添加于PostgreSQL 9.1。

按 PostgreSQL 版本定义

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