Wiki / SQL Commands

remove a row-level security policy from a table

English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.

anchor

SQL-DROPPOLICY

file

sql-droppolicy.html

lang

en

name

DROP POLICY

purpose

remove a row-level security policy from a table

purpose zh

从一个表中移除一条行级安全策略

sections same as

Unknown

slug

18

synopsis html

DROP POLICY [ IF EXISTS ] <em class="replaceable"><code>name</code></em> ON <em class="replaceable"><code>table_name</code></em> [ CASCADE | RESTRICT ]

synopsis text

DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

DROP POLICY p1 ON my_table;