Use the DROP TRIGGER command to remove a trigger from the database. Similar to the CREATE TRIGGER command, using this command requires you to be the owner of the trigger. The syntax to remove references to an existing trigger is:
Example 5-29. Dropping a Trigger - Syntax
DROP TRIGGER trigger_name ON table_name
After having successfully dropped the trigger, you should receive the message:
This error message might be displayed:
ERROR:Drop Trigger:there is no trigger name on relation "table"It means that the trigger does not exist in this database.