2008/4/25 Aleksander Kmetec - INTERA <[EMAIL PROTECTED]>: > Is there a way to get the time of the last insert, update or delete > statement for a specific table?
You can check the time stamp of the file corresponding the table after checkpoint. The relationship between the table name and the file name is in pg_class. SELECT relfilenode FROM pg_class WHERE relname = 'tablename'; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general