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:

  DROP
  

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.