50.67. pg_policies

The view pg_policies provides access to useful information about each row-level security policy in the database.

Table 50-68. pg_policies Columns

Name	Type	References	Description
`schemaname`	`name`	`pg_namespace.nspname`	Name of schema containing table policy is on
`tablename`	`name`	`pg_class.relname`	Name of table policy is on
`policyname`	`name`	`pg_policy.polname`	Name of policy
`roles`	`name[]`		The roles to which this policy applies
`cmd`	`text`		The command type to which the policy is applied
`qual`	`text`		The expression added to the security barrier qualifications for queries that this policy applies to
`with_check`	`text`		The expression added to the WITH CHECK qualifications for queries that attempt to add rows to this table

Prev		Next
`pg_matviews`	Up	`pg_prepared_statements`

© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/view-pg-policies.html