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 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