PG_SECLABELS

PG_SECLABELS displays information about security labels.

Table 1 PG_SECLABELS columns

Column

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

N/A

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

N/A

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

N/A

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