Contents
DROP POLICY
An SQL command to remove a row level security policy from a table
DROP POLICY is a DDL command to remove a row level security policy from a table.
DROP POLICY was added in PostgreSQL 9.5.
Change history
- PostgreSQL 9.6
CASCADEandRESTRICTsyntax documented as having no effect (commit 49978781)
- PostgreSQL 9.5
- added (commit 491c029d)
Note that DROP POLICY has not actually been modified since it was introduced in PostgreSQL 9.5, where the ineffective CASCADE and RESTRICT syntax was also added (but not documented until PostgreSQL 9.6).
References
- PostgreSQL documentation: DROP POLICY