Admins,
What is the best way to compare two rows from within psql cli client?
It has ~30 fields, and the two rows are duplicate data but there might
be differences.
id field1 field2 field3 ...
===========================
id1 value1 value2 value3 ...
id2 value1 value2 value3 ...
I could write a generic script to iterate through the list of fields and
compare each field values, or concatenate the fields to a string, but wondered what is out there.
Also, is there a way around to use select row(...) = row(...)?
Thanks.
--
Ben Kim