Updated on 2025-05-29 GMT+08:00

PG_SECLABEL

PG_SECLABEL records security labels on database objects.

See also PG_SHSECLABEL, which provides a similar function for security labels of database objects that are shared across a database cluster.

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 catalog that contains the current object.

objsubid

integer

-

No. of a column in the current object.

provider

text

-

Label provider associated with the current label.

label

text

-

Security label applied to this object.