Updated on 2022-07-15 GMT+08:00

PG_SECLABELS

PG_SECLABELS displays information about security labels.

Table 1 PG_SECLABEL columns

Name

Type

Reference

Description

objoid

oid

Any OID column

OID of the object this security label pertains to

classoid

oid

PG_CLASS.oid

OID of the system table that contains the object

objsubid

integer

-

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 0.

objtype

text

-

Type of the object to which this label applies

objnamespace

oid

PG_NAMESPACE.oid

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

objname

text

-

Name of the object to which the label applies

provider

text

PG_SECLABEL.provider

Label provider associated with this label

label

text

PG_SECLABEL.label

Security label applied to this object