pg_scd
It is a trigger based solution for SCD in PostgreSQL
In general it is a data versioning/historisation solution based on triggers. Slowly changing dimensions are only the prominent specimen of dimensional modelling but relational modelling can take advantage from it too. Its aim is to extract as much information from the information schema/catalogue of the data base to keep configuration as simple and robust as possible.