Postgresql流水帳(第七天):Trigger

標籤：

1. 建立一個函數
2. 建立一個trigger, 將表和函數綁定

?

ALTER TRIGGER trigger_name ON table_name

RENAME TO new_name;

?

ALTER TRIGGER last_name_changes ON employees

RENAME TO log_last_name_changes;

?

ALTER TABLE table_name

DISABLE TRIGGER trigger_name| ALL

You specify the trigger name after the?DISABLE TRIGGER?clause to disable a particular trigger. To disable all triggers associated with a table, you use?ALL?instead of a particular trigger name.

DROPTRIGGER[IFEXISTS]trigger_nameONtable_name;

Postgresql流水帳(第七天):Trigger