System Catalogs / System views
pg_policies
Read the PG 18 manualThe view pg_policies provides access to useful information about each row-level security policy in the database.
Reading PG 18current·documented in 13 of 24 versions, 9.5 to 20
- Kind
- System views
- Columns in this snapshot
- 8
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 8
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
schemaname | name | Name of schema containing table policy is on pg_namespace.nspname |
tablename | name | Name of table policy is on pg_class.relname |
policyname | name | Name of policy pg_policy.polname |
permissive | text | Is the policy permissive or restrictive? |
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 |
Column history across versions
Definition snapshot: english-manuals:2ec65f96c8b36c21e4d11a26186… · English manual source