pg_policies 是一个提供有关数据库中每个行级安全策略信息的系统目录视图。
pg_policies 添加于PostgreSQL 9.5。
按PostgreSQL版本定义
pg_policies (PostgreSQL 17)
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 | |
文档: pg_policies
pg_policies (PostgreSQL 16)
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 | |
文档: pg_policies
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 | |
文档: 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 | |
文档: 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 | |
文档: 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 | |
文档: 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 | | |
文档: 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 | | |
文档: 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 |
文档: 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 |
文档: pg_policies
更改历史记录
- PostgreSQL 10
- 添加了列
permissive（提交093129c9）
- 添加了列
- PostgreSQL 9.5
- 添加（提交491c029d）
参考文献
- PostgreSQL 文档： pg_policies