# 51.38. pg\_policy

The catalog `pg_policy` stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all commands), the roles that it applies to, the expression to be added as a security-barrier qualification to queries that include the table, and the expression to be added as a `WITH CHECK` option for queries that attempt to add new records to the table.

**Table 51.38. `pg_policy` Columns**

| Name            | Type           | References                                                                          | Description                                                                                                                             |
| --------------- | -------------- | ----------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- |
| `polname`       | `name`         |                                                                                     | The name of the policy                                                                                                                  |
| `polrelid`      | `oid`          | [`pg_class`](https://www.postgresql.org/docs/10/static/catalog-pg-class.html).oid   | The table to which the policy applies                                                                                                   |
| `polcmd`        | `char`         |                                                                                     | The command type to which the policy is applied: `r` for `SELECT`, `a` for `INSERT`, `w` for `UPDATE`, `d` for `DELETE`, or `*` for all |
| `polpermissive` | `boolean`      |                                                                                     | Is the policy permissive or restrictive?                                                                                                |
| `polroles`      | `oid[]`        | [`pg_authid`](https://www.postgresql.org/docs/10/static/catalog-pg-authid.html).oid | The roles to which the policy is applied                                                                                                |
| `polqual`       | `pg_node_tree` |                                                                                     | The expression tree to be added to the security barrier qualifications for queries that use the table                                   |
| `polwithcheck`  | `pg_node_tree` |                                                                                     | The expression tree to be added to the WITH CHECK qualifications for queries that attempt to add rows to the table                      |

## Note

Policies stored in `pg_policy` are applied only when `pg_class`.`relrowsecurity` is set for their table.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.postgresql.tw/internals/system-catalogs/pg_policy.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.