• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_SECLABELS

PG_SECLABELS

PG_SECLABELS provides 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 catalog this object appears in

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

objtype

text

-

Type of object to which this label applies, as text

objnamespace

oid

PG_NAMESPACE.oid

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

objname

text

-

Text-typed name of object to which this label applies

provider

text

PG_SECLABEL.provider

Label provider associated with this label

label

text

PG_SECLABEL.label

Security label applied to this object