PostgreSQL Triggers

Summary

In this chapter, we examined the basic concepts involved in working with triggers in PostgreSQL. We covered the six different characteristics that help define triggers, and we looked at how the characteristics affected trigger operation. We also discussed the differences involved in writing trigger functions compared to regular functions, and we showed a sample function and a trigger that put the function to use. While triggers are not directly interfaced, their functionality and usefulness can go a long way toward powering your applications and making your application code simpler and more effective.