Skip site navigation (1) Skip section navigation (2)

last insert/update for a table

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: last insert/update for a table
Date: 2010-01-20 17:00:43
Message-ID: 201001201000.43638.kevink@consistentstate.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all;

is there a system catalog query or function that will show me the last time an 
insert or update occurred for a specified table ?


Thanks in advance

Responses

pgsql-admin by date

Next:From: Brad NicholsonDate: 2010-01-20 17:12:38
Subject: Re: PostgreSQL backup idea
Previous:From: David F. SkollDate: 2010-01-20 16:29:46
Subject: Re: Warm standby problems: SOLVED

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group