Month: October 2017

A brief introduction to PostgreSQL/PostGIS trigger functions

Trigger functions are a useful tool for DB administrators since they can be used to automatically populate fields when rows are inserted, updated, or deleted. Trigger functions can be used to do such things as generate unique IDs that contain concatenated string and number fields, perform calculations on inputted fields, populate metadata fields (e.g. modified …