pg_seclabels

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog.

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: view
lang: en
measured attributes: true
metadata release: 18.6
runtime columns: objoid, classoid, objsubid, objtype, objnamespace, objname, provider, label
runtime verified: false
source: english-manual

Definition PG 18

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog.

Column	Type	Nullability	Description
objoid	oid	Nullable	The OID of the object this security label pertains to
classoid	oid	Nullable	The OID of the system catalog this object appears in
objsubid	int4	Nullable	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	Nullable	The type of object to which this label applies, as text.
objnamespace	oid	Nullable	The OID of the namespace for this object, if applicable; otherwise NULL.
objname	text	Nullable	The name of the object to which this label applies, as text.
provider	text	Nullable	The label provider associated with this label.
label	text	Nullable	The security label applied to this object.

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:f318d2f81907c1363e4dc15b1a5f1befbe8fbc006aa3defa6ce4d67de6b3b01a

Text language: en · catalog-bilingual-repair:f318d2f81907c1363e4dc15b1a5f1befbe8fbc006aa3defa6ce4d67de6b3b01a