ALTER EVENT TRIGGER — change the definition of an event trigger
ALTER EVENT TRIGGERnameDISABLE ALTER EVENT TRIGGERnameENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGERnameOWNER TO {new_owner| CURRENT_USER | SESSION_USER } ALTER EVENT TRIGGERnameRENAME TOnew_name
ALTER EVENT TRIGGER changes properties of an existing event trigger.
You must be superuser to alter an event trigger.
nameThe name of an existing trigger to alter.
new_ownerThe user name of the new owner of the event trigger.
new_nameThe new name of the event trigger.
DISABLE/ENABLE [ REPLICA | ALWAYS ]These forms configure the firing of event triggers. A disabled trigger is still known to the system, but is not executed when its triggering event occurs. See also session_replication_role.
There is no ALTER EVENT TRIGGER statement in the SQL standard.