1ALTER RULE(7)            PostgreSQL 14.3 Documentation           ALTER RULE(7)
2
3
4

NAME

6       ALTER_RULE - change the definition of a rule
7

SYNOPSIS

9       ALTER RULE name ON table_name RENAME TO new_name
10

DESCRIPTION

12       ALTER RULE changes properties of an existing rule. Currently, the only
13       available action is to change the rule's name.
14
15       To use ALTER RULE, you must own the table or view that the rule applies
16       to.
17

PARAMETERS

19       name
20           The name of an existing rule to alter.
21
22       table_name
23           The name (optionally schema-qualified) of the table or view that
24           the rule applies to.
25
26       new_name
27           The new name for the rule.
28

EXAMPLES

30       To rename an existing rule:
31
32           ALTER RULE notify_all ON emp RENAME TO notify_me;
33

COMPATIBILITY

35       ALTER RULE is a PostgreSQL language extension, as is the entire query
36       rewrite system.
37

SEE ALSO

39       CREATE RULE (CREATE_RULE(7)), DROP RULE (DROP_RULE(7))
40
41
42
43PostgreSQL 14.3                      2022                        ALTER RULE(7)