PG_SHSECLABEL
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.
| 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 where the object resides |
| provider | text | - | Label provider associated with this label |
| label | text | - | Security label applied to this object |
Last Article: PG_SHDESCRIPTION
Next Article: PG_STATISTIC
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.