pg_policies 是一个 系统目录 视图，提供数据库中每个行级安全策略的信息。
pg_policies 在 PostgreSQL 9.5 中添加。
按 PostgreSQL 版本定义
pg_policies (PostgreSQL 19)
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 18)
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 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
另请参阅
反馈
请在此处提交关于“pg_policies”的任何评论、建议或更正。