[Solved] What does a row-level trigger in PostgreSQL do? — Ans: It fires once for each row affected by the triggering statement. | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

What does a row-level trigger in PostgreSQL do?

AIt fires once per SQL statement regardless of affected rows.

BIt fires once for each row affected by the triggering statement.

CIt fires only before the entire transaction starts.

DIt fires only after the database server restarts.

Step-by-Step Solution

Solution:

Step 1: Understand the trigger types in PostgreSQL
Row-level triggers execute once for every row affected by an insert, update, or delete operation.
Step 2: Compare with statement-level triggers
Statement-level triggers execute once per statement, not per row.
Final Answer:
It fires once for each row affected by the triggering statement. -> Option B
Quick Check:
Row-level trigger = Fires per row [OK]

Quick Trick: Row-level triggers fire per row, statement-level per statement [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does a row-level trigger in PostgreSQL do?