On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <sim@compulab.co.il> wrote:

On 09/01/2011 12:26 PM, Pavel Stehule wrote:

Hello

postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1

postgres=# select md5(array_to_string(array_agg(md5(tt::text)),'')) from

I do that as well, but it might have questionable performance when
your table has 16M rows, and is 50GB +

I don't need performance. This is for regression testing for a new database version. I want to run my functions in the old db and the new db and when it modifies a table, I want to be able to check that the tables are the same.

Sim