We help IT Professionals succeed at work.

postges, how to get time when the table was last updated

rgbcof
rgbcof asked
on
How to get the time of when a particular table was last updated, had row inserted, or row deleted?
Comment
Watch Question

HI

Unfortunately there is nothing stored in pg that holds this information.
However , you can add a timestamp column to your table and update it via a trigger or a part of the SP code that updates your table (if you use SP for that)

Author

Commented:
I looked for it too, but couldn't find any.  Thanks for your confirmation. I did find add, update, and delete count statistic for each table, so I can use those.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.