NAME

ALTER_EVENT_TRIGGER - change the definition of an event trigger

SYNOPSIS

ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER name RENAME TO new_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))