I got this help and it worked for me.
1. Find the file node name from the pg_class for your table
select relfilenode from pg_class where relname = 'tablename'
2. Locate the relfilenode file in your system. The last updated system time
of that file node is your last update time of your table.
I hope it works for you.
SIVA JAN KAN
View this message in context: http://postgresql.1045698.n5.nabble.com/to-find-table-stats-for-last-update-time-tp2142054p4575271.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
In response to
pgsql-novice by date
|Next:||From: Roy's Email||Date: 2011-07-11 23:40:04|
|Subject: Creating DB programmatically?|
|Previous:||From: JORGE MALDONADO||Date: 2011-07-10 18:08:25|
|Subject: pgpass.cong file becomes empty|