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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to