DROP RULE name ON relation [ CASCADE | RESTRICT ]
The name of an existing rule to drop.
The name (optionally schema-qualified) of the relation the rule applies to.
Automatically drop objects that depend on the rule.
Refuse to drop the rule if there are any dependent objects. This is the default.
DROP RULE drops a rule from the specified PostgreSQL rule system. PostgreSQL will immediately cease enforcing it and will purge its definition from the system catalogs.