scd

Querying Historical Data in Postgres with the SCD Type 4 Pattern

A practical Postgres pattern using a history table, triggers, and valid_from/valid_to columns to answer point-in-time queries about record state in a single SELECT.