pg_policies
A system view providing information about each row-level security policy
pg_policies
is a system catalogue view providing information about each row-level security policy in the database.
pg_policies
was added in PostgreSQL 9.5.
Definition by PostgreSQL version
pg_policies (PostgreSQL 16)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | C | | with_check | text | C | |
Documentation: pg_policies
pg_policies (PostgreSQL 15)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | C | | with_check | text | C | |
Documentation: pg_policies
pg_policies (PostgreSQL 14)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | C | | with_check | text | C | |
Documentation: pg_policies
pg_policies (PostgreSQL 13)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | C | | with_check | text | C | |
Documentation: pg_policies
pg_policies (PostgreSQL 12)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | C | | with_check | text | C | |
Documentation: pg_policies
pg_policies (PostgreSQL 11)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | | | with_check | text | | |
Documentation: pg_policies
pg_policies (PostgreSQL 10)
View "pg_catalog.pg_policies" Column | Type | Collation | Nullable | Default ------------+--------+-----------+----------+--------- schemaname | name | | | tablename | name | | | policyname | name | | | permissive | text | | | roles | name[] | | | cmd | text | | | qual | text | | | with_check | text | | |
Documentation: pg_policies
pg_policies (PostgreSQL 9.6)
View "pg_catalog.pg_policies" Column | Type | Modifiers ------------+--------+----------- schemaname | name | tablename | name | policyname | name | roles | name[] | cmd | text | qual | text | with_check | text |
Documentation: pg_policies
pg_policies (PostgreSQL 9.5)
View "pg_catalog.pg_policies" Column | Type | Modifiers ------------+--------+----------- schemaname | name | tablename | name | policyname | name | roles | name[] | cmd | text | qual | text | with_check | text |
Documentation: pg_policies
Change history
- PostgreSQL 10
- column
permissive
added (commit 093129c9)
- column
- PostgreSQL 9.5
- added (commit 491c029d)
References
- PostgreSQL documentation: pg_policies