ALTER TRIGGER

Description

changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing the trigger definition. The DEPENDS ON EXTENSION clause marks the trigger as dependent on an extension, such that if the extension is dropped, the trigger will automatically be dropped as well.

You must own the table on which the trigger acts to be allowed to change its properties.

The name of the table on which this trigger acts.new_name

The new name for the trigger.

The name of the extension that the trigger is to depend on.

Notes

To rename an existing trigger:

To mark a trigger as being dependent on an extension:

Compatibility

is a PostgreSQL extension of the SQL standard.