DROP RULE is a DDL command for removing a rule.
DROP RULE has always been present in PostgreSQL, although it only became properly functional from PostgreSQL 6.4.
Change history
- PostgreSQL 8.2
DROP RULE IF EXISTS ...syntax added (commit bbcd0169)
- PostgreSQL 7.3
CASCADEandRESTRICTclauses added (commit 7c6df91d)
- PostgreSQL 6.4
- made functional (initial commit 15cb32d9)
References
- PostgreSQL documentation: DROP RULE