pg_seclabels
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 (commit 4d355a83).
Definition by PostgreSQL version
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