Saving Data Historically with Temporal Tables: Part 1: Queries


In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that allows you to see not only what the value of any column is currently, but at any point in time that your system is created to handle. In this three part series, I will aim to define what kind of information can be obtained from temporal tables and how to express requests for this information as SQL queries.

In this part 1 we explain concepts of temporal databases in general and outline major types of queries you will need for