Updated on 2024-06-03 GMT+08:00

PG_SECLABELS

PG_SECLABELS provides information about storage security labels.

Table 1 PG_SECLABELS columns

Name

Type

Reference

Description

objoid

oid

Any OID column

OID of the object that this security label pertains to.

classoid

oid

oid in PG_CLASS

OID of the system catalog where the object to which the security label belongs is located.

objsubid

integer

-

  • Column number for the security label on a table column (by referring to objoid and classoid in the table).
  • For all other object types, this column is set to 0.

objtype

text

-

Type of the object to which the label belongs, in text format. Examples:

  • table: table type.
  • column: column type.

objnamespace

oid

oid in PG_NAMESPACE

OID of the namespace for the object, if applicable; otherwise, NULL.

objname

text

-

Name of the object to which the label belongs, in text format.

provider

text

provider in PG_SECLABEL

Provider of the label.

label

text

label in PG_SECLABEL

Security label name.