-- Removes a rule from a database.
DROP RULE name[, ...]
The sole parameter of this command is the name of an existing rule to drop.
This message is displayed if the specified rule is dropped successfully.
- ERROR: Rule or view "name" not found
This error is displayed if the specified rule does not exist.
Use the DROP RULE command to remove the specified from a PostgreSQL database,
When a rule is dropped, the change is effective immediately. A rule becomes unavailable as soon as it is dropped
and its definition is removed from the database system completely.
The following example will drop the new_invoice rule.
DROP RULE new_invoice;