Name
DROP RULE
-- Removes a rule from a database.
Synopsis
DROP RULE name[, ...]
Parameters
- name
The sole parameter of this command is the name of an existing rule to drop.
Results
- 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.
Description
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.
Examples
The following example will drop the new_invoice rule.
DROP RULE new_invoice;