PostgreSQL Drop Trigger, syntax and example

Drop postgresql trigger

How to drop trigger, syntax and example.

Syntax

DROP TRIGGER [ IF EXISTS ] 
name ON table_name [ CASCADE | RESTRICT ];

Example – Drop postgresql trigger

DROP TRIGGER IF EXISTS 
customers_trigger ON customers CASCADE;

DROP TRIGGER IF EXISTS 
customers_trigger ON customers RESTRICT;

CASCADE – drop all objects that depend on the trigger.
RESTRICT – This is the default. Cancel to drop the trigger if any objects depend on it.