Triggers & Rules

8 pages in this section.

The mental model behind trigger timing, row-versus-statement firing, and how BEFORE/AFTER/INSTEAD OF triggers interact with MVCC and PostgreSQL's older rule system.

Explainer Sql Triggers Event Logic

Triggers Basics

Learn PostgreSQL trigger basics with nine examples, covering BEFORE/AFTER, row-level vs. statement-level, and trigger ordering.

Sql Triggers Rules Event Logic Basics Triggers

Transition Tables

Learn how to use SQL transition tables with statement-level triggers in PostgreSQL 18 for bulk OLD/NEW access, auditing, and performance.

Sql Triggers Rules Event Logic Transition Tables

Audit Triggers

Learn to implement audit triggers in PostgreSQL to capture data changes efficiently, ensuring high write throughput and detailed change tracking.

Sql Triggers Rules Event Logic List Audit

When Not to Use Triggers

Sql Triggers Rules Event Logic Anti Patterns

Rules (Legacy)

Sql Triggers Rules Event Logic Rules Legacy

Triggers Best Practices

Learn best practices for SQL triggers, including scoping, performance, and governance, to ensure efficient and maintainable database operations.

Sql Triggers Rules Event Logic Best Practices List

Triggers & Rules Highlights Summary

A single-page roundup of every highlight bullet from the 7 pages in the Triggers & Rules section, grouped by source page so you can scan all 40 takeaways without opening each article individually.

Highlights Summary Triggers Rules Event Logic

Triggers & Rules

Search Documentation

Triggers & Rules