Introduction to Triggers

Get introduced to triggers in PostgreSQL.

When a cache refresh policy of minutes isn’t advisable, a common approach is to implement event-based processing. Most SQL systems, including PostgreSQL, implement an event-based facility called a trigger.

Procedures and triggers

A trigger allows registering a procedure to be executed at a specified time when an event is produced. The timing can be before, after, or instead of, and the event can be insert, update, delete, or truncate.

Get hands-on with 1200+ tech skills courses.