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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general