pg_shseclabel

A system table storing security labels on shared database objects

pg_shseclabel is a system catalogue table storing security labels on shared database objects

pg_shseclabel was added in PostgreSQL 9.2.

This table is shared across all databases in a cluster.

Definition by PostgreSQL version

pg_shseclabel (PostgreSQL 15)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 14)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" PRIMARY KEY, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 13)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 12)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text | C         | not null | 
 label    | text | C         | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 11)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text |           | not null | 
 label    | text |           | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 10)

         Table "pg_catalog.pg_shseclabel"
  Column  | Type | Collation | Nullable | Default 
----------+------+-----------+----------+---------
 objoid   | oid  |           | not null | 
 classoid | oid  |           | not null | 
 provider | text |           | not null | 
 label    | text |           | not null | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 9.6)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | not null
 label    | text | not null
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 9.5)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | not null
 label    | text | not null
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider text_pattern_ops), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 9.4)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 9.3)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

pg_shseclabel (PostgreSQL 9.2)

Table "pg_catalog.pg_shseclabel"
  Column  | Type | Modifiers 
----------+------+-----------
 objoid   | oid  | not null
 classoid | oid  | not null
 provider | text | 
 label    | text | 
Indexes:
    "pg_shseclabel_object_index" UNIQUE, btree (objoid, classoid, provider), tablespace "pg_global"
Tablespace: "pg_global"

Documentation: pg_shseclabel

Change history

PostgreSQL 9.5
- definition of provider column in index pg_shseclabel_object_index changed to use text_pattern_ops (commit 0b28ea79)
- columns provider and label set to NOT NULL (commit 82a532b3)
PostgreSQL 9.2
- added (commit 463f2625)

References

PostgreSQL documentation: pg_shseclabel

Version charts

Useful overviews

Useful links

Contents

pg_shseclabel

Definition by PostgreSQL version

pg_shseclabel (PostgreSQL 15)

pg_shseclabel (PostgreSQL 14)

pg_shseclabel (PostgreSQL 13)

pg_shseclabel (PostgreSQL 12)

pg_shseclabel (PostgreSQL 11)

pg_shseclabel (PostgreSQL 10)

pg_shseclabel (PostgreSQL 9.6)

pg_shseclabel (PostgreSQL 9.5)

pg_shseclabel (PostgreSQL 9.4)

pg_shseclabel (PostgreSQL 9.3)

pg_shseclabel (PostgreSQL 9.2)

Change history

References

Categories

See also