I need to keep a copy of old data as the rows are changed.
For a general RDBMS I could think of keeping all the data in the same table
with a flag to indicate older copies of updated / deleted rows or keep a
parallel table and copy these rows into the parallel data under program /
trigger control. Each has its pros and cons.
In Postgres would i have to follow the same methods or are there any
features / packages available ?
regards
Sanjay Minni