pg_seclabels

A system catalogue view listing information about security labels

pg_seclabels is a view listing information about security labels, providing a more convenient format than the underlying pg_seclabel table.

pg_seclabels was added in PostgreSQL 9.1 (commit 4d355a83).

Definition by PostgreSQL version

pg_seclabels (PostgreSQL 13)

             View "pg_catalog.pg_seclabels"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 objoid       | oid     |           |          |
 classoid     | oid     |           |          |
 objsubid     | integer |           |          |
 objtype      | text    |           |          |
 objnamespace | oid     |           |          |
 objname      | text    | C         |          |
 provider     | text    | C         |          |
 label        | text    | C         |          |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 12)

             View "pg_catalog.pg_seclabels"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 objoid       | oid     |           |          |
 classoid     | oid     |           |          |
 objsubid     | integer |           |          |
 objtype      | text    |           |          |
 objnamespace | oid     |           |          |
 objname      | text    | C         |          |
 provider     | text    | C         |          |
 label        | text    | C         |          |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 11)

             View "pg_catalog.pg_seclabels"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 objoid       | oid     |           |          |
 classoid     | oid     |           |          |
 objsubid     | integer |           |          |
 objtype      | text    |           |          |
 objnamespace | oid     |           |          |
 objname      | text    |           |          |
 provider     | text    |           |          |
 label        | text    |           |          |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 10)

             View "pg_catalog.pg_seclabels"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 objoid       | oid     |           |          |
 classoid     | oid     |           |          |
 objsubid     | integer |           |          |
 objtype      | text    |           |          |
 objnamespace | oid     |           |          |
 objname      | text    |           |          |
 provider     | text    |           |          |
 label        | text    |           |          |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.6)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.5)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.4)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.3)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.2)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

pg_seclabels (PostgreSQL 9.1)

   View "pg_catalog.pg_seclabels"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 objoid       | oid     |
 classoid     | oid     |
 objsubid     | integer |
 objtype      | text    |
 objnamespace | oid     |
 objname      | text    |
 provider     | text    |
 label        | text    |
    

Documentation: pg_seclabels

Change history

This view has not been modified since it was introduced in PostgreSQL 9.1.

Categories

Security, System catalogue

See also

pg_seclabel