Managing PostgreSQL triggers

--How to modify the trigger
--example : alter trigger trigger_name on table_name
--rename to new_name

alter trigger last_name_changes
on santri
rename to log_last_name_change;

alter trigger first_name_changes
on santri
rename to log_first_name_change;


--How to disabling the trigger
--example : alter table table_name
--disable trigger trigger_name | all

--example : first trigger
alter table santri
disable trigger log_last_name_change;

alter table santri
disable trigger log_first_name_change;

--example all trigger
alter table santri
disable trigger all;

--How to Removing the trigger
--example : drop trigger [if exists] trigger_name
--        on table_name [restrict | cascade]

drop trigger log_last_name_change
on santri;

drop trigger log_first_name_change
on santri;