pg_seclabels
A system 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.
Definition by PostgreSQL version
pg_seclabels (PostgreSQL 16)
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 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.
- PostgreSQL 9.1
- added (commit 4d355a83)
References
- PostgreSQL documentation: pg_seclabels