Is there an md5sum for tables?
| От | Michael Enke |
|---|---|
| Тема | Is there an md5sum for tables? |
| Дата | |
| Msg-id | 47F303F6.1070708@wincor-nixdorf.com обсуждение исходный текст |
| Ответы |
Re: Is there an md5sum for tables?
Re: Is there an md5sum for tables? Re: Is there an md5sum for tables? Re: Is there an md5sum for tables? Re: Is there an md5sum for tables? |
| Список | pgsql-general |
Hi all, I need to know if multiple tables have (may have most probably) identical content. Since I want a fast solution (which means not comparing tables row by row), I thought it would be a good idea to have an sql function operating on a table or view similar to md5sum on a file and only compare the generated hashes. I did not find such a function in the documentation. Is such a function already available? If not, does it make no sense to use such an approach? Regards, Michael -- Wincor Nixdorf International GmbH Sitz der Gesellschaft: Paderborn Registergericht Paderborn HRB 3507 Gesch�ftsf�hrer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. J�rgen Wunram Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193 Diese E-Mail enth�lt vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt�mlich erhaltenhaben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie dieunbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail may contain confidential information. If you are not the intended recipient (or have received this e-mail inerror) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distributionof the material in this e-mail is strictly forbidden.
В списке pgsql-general по дате отправления: