Compute hash of a table?

From: "Peter Manchev" <pmanchev(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Compute hash of a table?
Date: 2006-05-02 18:54:55
Message-ID: BAY101-F1120BA806F30837AA2161BC5B60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Catalin Pitis 2006-05-02 19:13:53 ERROR: plan should not reference subplan's variable
Previous Message Jorge Godoy 2006-05-02 17:14:48 Creating nested functions with plpgsql