pg_seclabel
A system 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.
Definition by PostgreSQL version
pg_seclabel (PostgreSQL 15)
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" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)
Documentation: pg_seclabel
pg_seclabel (PostgreSQL 14)
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" PRIMARY KEY, btree (objoid, classoid, objsubid, provider)
Documentation: pg_seclabel
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
- PostgreSQL 9.5
- PostgreSQL 9.1
- added (commit 4d355a83)
References
- PostgreSQL dcumentation: pg_seclabel