From: Peter Manchev <pmanchev@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Compute hash of a table?
Date: Tue, 02 May 2006 11:54:55 -0700
Message-ID: <BAY101-F1120BA806F30837AA2161BC5B60@phx.gbl> (raw)
Hi All
I need to determine whether the content of a given table has changed from
the previous time I've checked it. so, my initial idea is to calculate a
hash value of the content of the whole table, may be with custom aggregate
function or something.
My question is:
Is it possible to get the last time(stamp) when the content of a given table
in pgsql has changed???
Thanks!
Pete
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pmanchev@hotmail.com
Subject: Re: Compute hash of a table?
In-Reply-To: <BAY101-F1120BA806F30837AA2161BC5B60@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox