Ben Kim <bkim(at)tamu(dot)edu> writes:> What is the best way to compare two rows from within psql cli client?
In 8.4 and up you can just compare the row values, eg select x.* = y.*if x and y are known to be of the same rowtype.
regards, tom lane