pg_seclabel

A system catalogue table storing security labels for database objects

pg_seclabel is a system catalogue table storing security labels for database objects

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

Definition by PostgreSQL version

pg_seclabel (PostgreSQL 13)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null |
 classoid | oid     |           | not null |
 objsubid | integer |           | not null |
 provider | text    | C         | not null |
 label    | text    | C         | not null |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 12)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null |
 classoid | oid     |           | not null |
 objsubid | integer |           | not null |
 provider | text    | C         | not null |
 label    | text    | C         | not null |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 11)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null |
 classoid | oid     |           | not null |
 objsubid | integer |           | not null |
 provider | text    |           | not null |
 label    | text    |           | not null |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 10)

           Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Collation | Nullable | Default
----------+---------+-----------+----------+---------
 objoid   | oid     |           | not null |
 classoid | oid     |           | not null |
 objsubid | integer |           | not null |
 provider | text    |           | not null |
 label    | text    |           | not null |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.6)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | not null
 label    | text    | not null
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.5)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    | not null
 label    | text    | not null
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider text_pattern_ops)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.4)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    |
 label    | text    |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.3)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    |
 label    | text    |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.2)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    |
 label    | text    |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

pg_seclabel (PostgreSQL 9.1)

 Table "pg_catalog.pg_seclabel"
  Column  |  Type   | Modifiers
----------+---------+-----------
 objoid   | oid     | not null
 classoid | oid     | not null
 objsubid | integer | not null
 provider | text    |
 label    | text    |
Indexes:
    "pg_seclabel_object_index" UNIQUE, btree (objoid, classoid, objsubid, provider)
    

Documentation: pg_seclabel

Change history

This table has not been modified since it was added in PostgreSQL 9.1.

Categories

Security, System catalogue

See also

pg_seclabels, pg_shseclabel, SECURITY LABEL