pg_seclabel
The catalog pg_seclabel stores security labels on 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_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster.
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, objsubid, provider, label
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_seclabel stores security labels on 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_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster.
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 |
| objsubid | int4 | Not null | 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. |
| 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:c72ccdb37479b0315eaa01b1e444a47259830c9042e7e027abc8cc047dc4d751
Text language: en · catalog-bilingual-repair:c72ccdb37479b0315eaa01b1e444a47259830c9042e7e027abc8cc047dc4d751