Postgres Pro
Downloads
Home   >   mailing lists

md5 of table - Mailing list pgsql-general

From Sim Zacks
Subject md5 of table
Date
Msg-id 4E5F469C.5070104@compulab.co.il
Whole thread Raw
Responses Re: md5 of table
Re: md5 of table
List pgsql-general
Tree view 
Is there a way to get an md5 or other hash of an entire table?

I want to be able to easily compare 2 tables in different databases.

I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.

If I could return an md5 of the entire table, then I could check if the
tables have the same hash and be confident enough that the tables were
identical.


Thanks
Sim

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: function param and declared variable of same name
Next
From: Karsten Hilbert
Date:
Subject: Re: md5 of table