Morioh
Login
Charity Ferry

Charity Ferry

2 years ago

SQL Triggers, also called Database Triggers, allow you to tell your SQL engine (for these examples, Postgres) to run a piece of code when an event happens, or even before the event.

Advantages of using SQL Triggers

  • Maintaining data integrity
  • Separating business logic
  • Atomic transactions

#postgresql #postgresql trigger #trigger #sql

A Complete Guide to SQL Triggers in PostgreSQL

blog.arctype.com

A Complete Guide to SQL Triggers in PostgreSQL

SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.

1.10 GEEK