PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_seclabel

Read PG 18 manual ↗

The catalog pg_seclabel stores security labels on database objects.

Kind: System catalogs
Columns in this snapshot: 5
Definition source: English manual

Columns 5

Column	Type	Description / reference
`objoid`	`oid`	The OID of the object this security label pertains to
`classoid`	`oid`	The OID of the system catalog this object appears in pg_class.oid
`objsubid`	`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.
`provider`	`text`	The label provider associated with this label.
`label`	`text`	The security label applied to this object.

Column history across versions

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	20
`objoid`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`classoid`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`objsubid`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`provider`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`label`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 15

Definition snapshot: english-manuals:fdda77e412e491631a48cec319e… · English manual source