alter_event_trigger(7)

NAME#

ALTER_EVENT_TRIGGER - change the definition of an event trigger

SYNOPSIS#

ALTER EVENT TRIGGER \nname\n DISABLE
ALTER EVENT TRIGGER \nname\n ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER \nname\n OWNER TO { \nnew_owner\n | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER \nname\n RENAME TO \nnew_name

DESCRIPTION#

ALTER EVENT TRIGGER changes properties of an existing event trigger.

You must be superuser to alter an event trigger.

PARAMETERS#

name

new_owner

new_name

DISABLE/ENABLE [ REPLICA | ALWAYS ]

COMPATIBILITY#

There is no ALTER EVENT TRIGGER statement in the SQL standard.

SEE ALSO#

CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)), DROP EVENT TRIGGER (DROP_EVENT_TRIGGER(7))