Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_SECLABELS

PG_SECLABELS

Updated at: Jul 15, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel