Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

B. Shaik, D. K. ChemuduruProcedural Programming with PostgreSQL PL/pgSQLhttps://doi.org/10.1007/978-1-4842-9840-4_15

15. Triggers

Baji Shaik¹   and Dinesh Kumar Chemuduru²

(1)

Texas, TX, USA

(2)

Andhra Pradesh, India

 

In the previous chapter, we talked about the different types of exceptions available in PL/pgSQL and how to handle them with some examples. In this chapter, we will cover triggers in PostgreSQL. It will start with the introduction of triggers and how to create them using PL/pgSQL code with a simple example. We will then talk about the types of triggers with some use cases and real-world examples of where and when to use these triggers using PL/pgSQL ...