pg_seclabels 是一个列出安全标签信息的系统目录视图，它提供了比底层 pg_seclabel 表更方便的格式。
pg_seclabels 在 PostgreSQL 9.1 中被添加。
按 PostgreSQL 版本定义
pg_seclabels (PostgreSQL 19)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 18)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 17)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 16)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 15)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 14)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 13)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 12)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | C | |
provider | text | C | |
label | text | C | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 11)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | | |
provider | text | | |
label | text | | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 10)
View "pg_catalog.pg_seclabels"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
objoid | oid | | |
classoid | oid | | |
objsubid | integer | | |
objtype | text | | |
objnamespace | oid | | |
objname | text | | |
provider | text | | |
label | text | | |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.6)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.5)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.4)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.3)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.2)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
pg_seclabels (PostgreSQL 9.1)
View "pg_catalog.pg_seclabels"
Column | Type | Modifiers
--------------+---------+-----------
objoid | oid |
classoid | oid |
objsubid | integer |
objtype | text |
objnamespace | oid |
objname | text |
provider | text |
label | text |
文档: pg_seclabels
变更历史
自从 PostgreSQL 9.1 引入以来，该视图未被修改。
- PostgreSQL 9.1
- 已添加 (提交 4d355a83)
参考资料
- PostgreSQL 文档: pg_seclabels