on delete trigger in postgresql example

Example: how to drop a trigger in postgresql

DROP TRIGGER [IF EXISTS] trigger-name 
ON table-name [ CASCADE | RESTRICT ];