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 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
permissiveadded (commit 093129c9)
- column
- PostgreSQL 9.5
- added (commit 491c029d)
References
- PostgreSQL documentation: pg_policies