Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Catalogs/ PG_SECLABEL
Updated on 2025-10-09 GMT+08:00
View PDF

PG_SECLABEL

PG_SECLABEL records security labels on database objects.

See also PG_SHSECLABEL, which performs 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 object

objsubid

Integer

N/A

For a security label on a table column, this is the column number.

provider

Text

N/A

Label provider associated with this label

label

Text

N/A

Security label applied to this object
Parent Topic: System Catalogs