check the log of postgresql, there you can take the table name and the date of the modification
Ing. Lennin Caro Pérez Usuario:GNU/LINUX PHP Developer PostgreSQL DBA Oracle DBA Linux counter id 474393 --- On Mon, 2/27/12, Tatsuo Ishii <[email protected]> wrote: From: Tatsuo Ishii <[email protected]> Subject: Re: [HACKERS] How to know a table has been modified? To: [email protected] Cc: [email protected] Date: Monday, February 27, 2012, 12:04 PM >> For TRIGGER, I cannot thinking of any way. Any idea will be >> welcome. > > It would require creating "cooperating" triggers in the database and > having a listener, but you might consider the > triggered_change_notifications() trigger function included in 9.2. > It works at least as far back as 9.0; I haven't tried it any further > back. Thanks for the info. It's a little bit overkill for my purpose though. (on busy systems, the notification would be too frequent). I would think that creating a small routine periodically consults pg_stat_all_tables view and records the last update datetime for each table (unfortunately the view does not have last modification date). -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
