PostgreSQL 9.1 ← 9.0Catalog added
← Catalog atlas / pg_seclabels
SYSTEM VIEW · System view
pg_seclabels
The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_seclabelsPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
objoid |
oid |
The OID of the object this security label pertains toReferences:any OID column |
classoid |
oid |
The OID of the system catalog this object appears inReferences:pg_class.oid |
objsubid |
integerDocumented as:int4 |
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. |
objtype |
text |
The type of object to which this label applies, as text. |
objnamespace |
oid |
The OID of the namespace for this object, if applicable; otherwise NULL.References:pg_namespace.oid |
objname |
text |
The name of the object to which this label applies, as text. |
provider |
text |
The label provider associated with this label.References:pg_seclabel.provider |
label |
text |
The security label applied to this object.References:pg_seclabel.label |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objoid |
– | ||||||||||||||||
classoid |
– | ||||||||||||||||
objsubid |
– | ||||||||||||||||
objtype |
– | ||||||||||||||||
objnamespace |
– | ||||||||||||||||
objname |
– | ||||||||||||||||
provider |
– | ||||||||||||||||
label |
– |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsCompare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.