45.61. pg_seclabels

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

Table 45-62. pg_seclabels Columns

NameTypeReferencesDescription
objoidoidany OID columnThe OID of the object this security label pertains to
classoidoidpg_class.oidThe OID of the system catalog this object appears in
objsubidint4  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.
objtypetext  The type of object to which this label applies, as text.
objnamespaceoidpg_namespace.oid The OID of the namespace for this object, if applicable; otherwise NULL.
objnametext  The name of the object to which this label applies, as text.
providertextpg_seclabel.providerThe label provider associated with this label.
labeltextpg_seclabel.labelThe security label applied to this object.