alter_trigger(7)

1ALTER TRIGGER()                  SQL Commands                  ALTER TRIGGER()
2
3
4

NAME

6       ALTER TRIGGER - change the definition of a trigger
7
8

SYNOPSIS

10       ALTER TRIGGER name ON table RENAME TO newname
11
12

DESCRIPTION

14       ALTER  TRIGGER  changes  properties  of an existing trigger. The RENAME
15       clause changes the name of the given trigger without otherwise changing
16       the trigger definition.
17
18       You  must  own  the  table  on  which the trigger acts to be allowed to
19       change its properties.
20

PARAMETERS

22       name   The name of an existing trigger to alter.
23
24       table  The name of the table on which this trigger acts.
25
26       newname
27              The new name for the trigger.
28

NOTES

30       The ability to temporarily enable or disable a trigger is  provided  by
31       ALTER TABLE [alter_table(7)], not by ALTER TRIGGER, because ALTER TRIG‐
32       GER has no convenient way to express the option  of  enabling  or  dis‐
33       abling all of a table's triggers at once.
34

EXAMPLES

36       To rename an existing trigger:
37
38       ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
39
40

COMPATIBILITY

42       ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
43