drop_rule(7) - BetterMan

drop_rule(7)

remove a rewrite rule

distrodataset 2026-04-01T06:19:02Z+debian+ec4110e+mandoc:1.14.6-4

Synopsis

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

—

NAME

DROP_RULE - remove a rewrite rule

bash

DROP RULE [ IF EXISTS ] \nname\n ON \ntable_name\n [ CASCADE | RESTRICT ]

DROP RULE drops a rewrite rule.

IF EXISTS

name

table_name

CASCADE

RESTRICT

To drop the rewrite rule newrule:

bash

DROP RULE newrule ON mytable;

DROP RULE is a PostgreSQL language extension, as is the entire query rewrite system.