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

PG_SHSECLABEL

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

PG_SHSECLABEL records security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command.

For an easier way to view security labels, see PG_SECLABELS.

See also PG_SECLABEL, which performs a similar function for security labels involving objects within a single database.

Unlike most system catalogs, PG_SHSECLABEL is shared across all databases of a cluster. There is only one copy of PG_SHSECLABEL per cluster, not one per database.

Table 1 PG_SHSECLABEL 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

provider

text

-

Label provider associated with this label

label

text

-

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