ALTER COMMAND TRIGGER
7
SQL - Language Statements
ALTER COMMAND TRIGGER
change the definition of a trigger
ALTER COMMAND TRIGGER
ALTER COMMAND TRIGGER name ON command SET enabled
where enabled can be one of:
ENABLE
ENABLE ALWAYS
ENABLE REPLICA
DISABLE
Description
ALTER COMMAND TRIGGER changes properties of an
existing command trigger.
You must be superuser to alter a command trigger.
Parameters
name
The name of an existing trigger to alter.
command
The command tag on which this trigger acts.
enabled
When to enable this trigger. See
the session_replication_role parameter.
Compatibility
ALTER COMMAND TRIGGER is a PostgreSQL>
extension of the SQL standard.
See Also