pg_policies

A system catalogue 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 (commit 491c029d).

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

Categories

Security, System catalogue

See also

pg_policy