SYSTEM VIEW · 系统视图

pg_seclabels

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog.

首次收录 PG 9.1最近收录 PG 19当前字段 8

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 PostgreSQL 18

pg_seclabels

字段 / COLUMN	类型 / TYPE	说明 / DESCRIPTION
`objoid`	`oid`	The OID of the object this security label pertains to引用：`any OID column`
`classoid`	`oid`	The OID of the system catalog this object appears in引用：`pg_class.oid`
`objsubid`	`integer`文档原写法：`int4`	For a security label on a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.
`objtype`	`text`	The type of object to which this label applies, as text.
`objnamespace`	`oid`	The OID of the namespace for this object, if applicable; otherwise NULL.引用：`pg_namespace.oid`
`objname`	`text`	The name of the object to which this label applies, as text.
`provider`	`text`	The label provider associated with this label.引用：`pg_seclabel.provider`
`label`	`text`	The security label applied to this object.引用：`pg_seclabel.label`

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

悬停查看字段类型

存在新增 / 类型或属性变化移除

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

相邻大版本的变化

PostgreSQL 9.1 ← 9.0新增目录

+ objoid+ classoid+ objsubid+ objtype+ objnamespace+ objname+ provider+ label

起始版本 / FROM目标版本 / TO包含描述更新

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。