August 9, 2024
A PostgreSQL trigger is a function invoked automatically whenever an event such as insert, update, or delete occurs. In this section, you will learn about triggers and how to manage them effectively.
- Introduction to PostgreSQL trigger – give you a brief overview of PostgreSQL triggers, why you should use triggers, and when to use them.
- Create trigger – show you step by step how to create your first trigger in PostgreSQL.
- Drop trigger– describe steps of how to use the
DROP TRIGGERstatement to delete a trigger from a table. - List triggers – shows you how to list triggers in PostgreSQL database.
- Alter trigger – guide you on how to use the
ALTER TRIGGERstatement to rename a trigger. - Disable trigger – show how how to disable a trigger or all triggers that belong to a table.
- Enable triggers – learn how to enable a trigger or all triggers associated with a table.
- Event Trigger – Introduce the event trigger that fires when an event related to a DDL statement occurs.
- Conditional trigger – Define a conditional trigger that fires only when a condition is satisfied.