Like with any other database, we should be taking regular dumps of backup of the database for recovery, migration, or any other purposes. There are three fundamentally different approaches to. read more…
PL/pgSQL can be used to define trigger functions on data changes or database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function with no arguments and. read more…
Backing up and Restoring the PostgreSQL Cluster
Like with any other database, we should be taking regular dumps of backup of the database for recovery, migration, or any other purposes. There are three fundamentally different approaches to. read more…
Continue Reading
Creating Trigger Functions
PL/pgSQL can be used to define trigger functions on data changes or database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function with no arguments and. read more…
Continue Reading