51.45. pg_seclabel

51.45. `pg_seclabel`
Prev	Up	Chapter 51. System Catalogs	Home	Next

The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 51.84 .

See also pg_shseclabel , which performs a similar function for security labels of database objects that are shared across a database cluster.

Table 51.45. pg_seclabel Columns

Name	Type	References	Description
`objoid`	`oid`	any OID column	The OID of the object this security label pertains to
`classoid`	`oid`	`pg_class .oid`	The OID of the system catalog this object appears in
`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.

Prev	Up	Next
51.44. `pg_rewrite`	Home	51.46. `pg_sequence`