↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

支持中的版本: 当前版本 (18) / 17 / 16 / 15 / 14
开发中的版本: 19 / 20devel
已结束支持的版本: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.

45.63. pg_seclabels #

视图pg_seclabels提供有关安全标签的信息。它是 pg_seclabel目录的更易查询版本。

表 45.64. pg_seclabels 列

NameTypeReferencesDescription
objoidoidany OID columnThe OID of the object this security label pertains to
classoidoidpg_class.oidThe OID of the system catalog this object appears in
objsubidint4  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.
objtypetext  The type of object to which this label applies, as text.
objnamespaceoidpg_namespace.oid The OID of the namespace for this object, if applicable; otherwise NULL.
objnametext  The name of the object to which this label applies, as text.
providertextpg_seclabel.providerThe label provider associated with this label.
labeltextpg_seclabel.labelThe security label applied to this object.

报告文档问题

阅读 上游文档. 反馈更正前请先核对 当前版本手册.