In PostgreSQL, what is the difference between a BEFORE trigger and an AFTER trigger on a row-level INSERT?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

In PostgreSQL, what is the difference between a BEFORE trigger and an AFTER trigger on a row-level INSERT?

Key points

BEFORE triggers can modify or cancel the row
AFTER triggers cannot modify the row
Timing of trigger execution is crucial in PostgreSQL

Ready to go further?

Start full exam Practice more questions

Related questions