System Catalogs / System catalogs
pg_seclabel
Read the PG 18 manualThe catalog pg_seclabel stores security labels on database objects.
Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
objoid | oidNOT NULL | The OID of the object this security label pertains to |
classoid | oidNOT NULL | The OID of the system catalog this object appears in pg_class.oid |
objsubid | int4NOT 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 | textNOT NULL | The label provider associated with this label. |
label | textNOT NULL | The security label applied to this object. |
Column history across versions
Version history 15
Definition snapshot: english-manuals:56c0a78968359a41fef4d9dfa28… · English manual source