I'm trying to load data from kafka topics to several tables in postgres. Do we have any table in postgres which will tell which table is modified or updated recently??
Asked
Active
Viewed 33 times
0
-
Have you considered adding a `last_changed` column to your tables, e.g. with a `DEFAULT NOW()`? – Jim Jones Jun 21 '21 at 05:50
-
https://stackoverflow.com/questions/32512474/ – a_horse_with_no_name Jun 21 '21 at 05:52
1 Answers
0
No. You will have to collect that information yourself, fir example using triggers.
Laurenz Albe
- 167,868
- 16
- 137
- 184