Introduction If you’re using TimescaleDB to store and manage data that changes with time, you may wonder if you can implement triggers in this time-series database. The answer is “yes”: TimescaleDB supports the table objects that are supported by PostgreSQL, which includes indexes, data types and triggers. You can use the PostgreSQL CREATE TRIGGER statement … Continued

How to Create a PostgreSQL CREATE FUNCTION Statement

Introduction This tutorial will explain how to create a PostgreSQL CREATE FUNCTION using the CREATE TRIGGER statement. The CREATE TRIGGER statement will initiate a new trigger that will be connected to a specific table to execute a specified command when specific events occur. The trigger can be created to fire before the operation is initiated … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.