1DROP EVENT TRIGGER(7)    PostgreSQL 12.2 Documentation   DROP EVENT TRIGGER(7)
2
3
4

NAME

6       DROP_EVENT_TRIGGER - remove an event trigger
7

SYNOPSIS

9       DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP EVENT TRIGGER removes an existing event trigger. To execute this
13       command, the current user must be the owner of the event trigger.
14

PARAMETERS

16       IF EXISTS
17           Do not throw an error if the event trigger does not exist. A notice
18           is issued in this case.
19
20       name
21           The name of the event trigger to remove.
22
23       CASCADE
24           Automatically drop objects that depend on the trigger, and in turn
25           all objects that depend on those objects (see Section 5.14).
26
27       RESTRICT
28           Refuse to drop the trigger if any objects depend on it. This is the
29           default.
30

EXAMPLES

32       Destroy the trigger snitch:
33
34           DROP EVENT TRIGGER snitch;
35

COMPATIBILITY

37       There is no DROP EVENT TRIGGER statement in the SQL standard.
38

SEE ALSO

40       CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)), ALTER EVENT TRIGGER
41       (ALTER_EVENT_TRIGGER(7))
42
43
44
45PostgreSQL 12.2                      2020                DROP EVENT TRIGGER(7)