GNU/Linux |
RedHat 5.2(Apollo) |
|
![]() |
drop_rule(l) |
![]() |
drop rule − removes a current rule from Postgres
drop rule rule_name
This command drops the rule named rule_name from the specified Postgres rule system. Postgres will immediately cease enforcing it and will purge its definition from the system catalogs.
--
--This example drops the rewrite rule example_1
--
drop rule example_1
create rule(l), drop view(l).
Once a rule is dropped, access to historical information the rule has written may disappear.
![]() |
drop_rule(l) | ![]() |