Managing Trigger Postgres

-- Modifying the Trigger
ALTER TRIGGER Jurusan_change
ON SCHOOL
RENAME TO Jurusan_changed;

-- Disabling the Trigger
> FOR DISABLE ONE TRIGGER
ALTER TABLE SCHOOL
DISABLE TRIGGER Jurusan_changed;

> FOR DISABLE ALL TRIGGER
ALTER TABLE SCHOOL
DISABLE TRIGGER ALL;

-- Removing the Trigger
DROP TRIGGER Jurusan_changed
ON SCHOOL;