pg_shseclabel
A system catalogue 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 introduced in PostgreSQL 9.2 (commit 463f2625).
This table is shared across all databases in a cluster.
Definition by PostgreSQL version
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
This table has remained unchanged since its introduction in PostgreSQL 9.2.
References
- PostgreSQL documentation: pg_shseclabel