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 101 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/ – Jun 21 '21 at 05:52
1 Answers
0
No. You will have to collect that information yourself, fir example using triggers.
Laurenz Albe
- 209,280
- 17
- 206
- 263