51.83. pg_seclabels

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

Table 51.84. pg_seclabels Columns

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.oidThe 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.
Updated at: 7 months ago
51.82. pg_rulesTable of content51.84. pg_sequences