Re: md5 of table

Sim Zacks <sim@xxxxxxxxxxxxxx> · Thu, 01 Sep 2011 15:10:22 +0300



    On 09/01/2011 01:35 PM, Grzegorz Jaśkiewicz wrote:
    
      On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks <sim@xxxxxxxxxxxxxx> 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