Query: alter_trigger
OS: debian
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
ALTERTRIGGER(7) SQL Commands ALTER TRIGGER(7)NAMEALTER TRIGGER - change the definition of a triggerSYNOPSISALTER TRIGGER name ON table RENAME TO newnameDESCRIPTIONALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing the trigger definition. You must own the table on which the trigger acts to be allowed to change its properties.PARAMETERSname The name of an existing trigger to alter. table The name of the table on which this trigger acts. newname The new name for the trigger.NOTESThe ability to temporarily enable or disable a trigger is provided by ALTER TABLE [alter_table(7)], not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.EXAMPLESTo rename an existing trigger: ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;COMPATIBILITYALTER TRIGGER is a PostgreSQL extension of the SQL standard.SEE ALSOALTER TABLE [alter_table(7)] SQL - Language Statements 2010-05-14 ALTER TRIGGER(7)