Answer the question
In order to leave comments, you need to log in
What is the optimal way to store the historical data of table records?
There is a table
CREATE TABLE entity (
id int PRIMARY KEY,
a text,
b text,
c text); -- полей больше, но не суть
CREATE TABLE entity_history (
id int REFERENCES entity(id),
a text,
b text,
c text,
changed_at timestamp
);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question