pg_shseclabel
The catalog pg_shseclabel stores 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 Section 53.23. 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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- objoid, classoid, provider, label
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_shseclabel stores 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 Section 53.23. 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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| objoid | oid | Not null | The OID of the object this security label pertains to |
| classoid | oid | Not null | The OID of the system catalog this object appears in |
| provider | text | Not null | The label provider associated with this label. |
| label | text | Not null | The security label applied to this object. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:9854dfab47707e14dca692b6e0b3b5b52e12d46a8abc8c7d6ddc9768b784daa6
Text language: en · catalog-bilingual-repair:9854dfab47707e14dca692b6e0b3b5b52e12d46a8abc8c7d6ddc9768b784daa6