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 15)

             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 14)

             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 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