table's last update time

From: Alexandru Maximciuc <amaximciuc(at)bitdefender(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: table's last update time
Date: 2009-06-23 21:26:22
Message-ID: 341163149.20090624002622@bitdefender.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello people,

I was curious if there are any hacks to see the time a table was last changed
at (insert or update or delete of some rows).

I googled a little and it seems that a trigger is the best solution, but is it
possible without triggers?

thanks in advance.

--
Best regards,
Alexandru mailto:amaximciuc(at)bitdefender(dot)com

Browse pgsql-novice by date

  From Date Subject
Next Message Nagle, Gail A (US SSA) 2009-06-24 00:48:03 Configuring autovacuum for the first time...
Previous Message Robert Schnabel 2009-06-22 23:29:24 Re: Problems importing csv files