@elisha_langworth 1) Connect to the PostgreSQL database server using any client tool such as psql or pgAdmin.
2) Run the following DROP TRIGGER statement to drop the trigger:
1
|
DROP TRIGGER [trigger_name] ON [table_name]; |
3) Verify the trigger was dropped successfully by querying the schema:
1
|
SELECT * FROM pg_trigger WHERE tgname = '[trigger_name]'; |
4) If the query returns any rows then the trigger was deleted successfully.