January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQLBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Drop Rule
Removes a rule from a database.
Synopsis
DROP RULE name [, ...]Parameters
nameThe name of an existing rule to drop. You may drop multiple rules by specifying their names in a comma-delimited list.
Results
DROPThe message returned when a rule is dropped successfully.
ERROR: Rule or view "name" not foundThe error returned if the specified rule
namedoes not exist.
Description
Use the DROP RULE command to remove a rule 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 completely removed from the database
system.
Example
The following example drops the sync_stock_with_editions rule:
booktown=# DROP RULE sync_stock_with_editions;
DROP