compare two rows - Mailing list pgsql-admin

From Ben Kim
Subject compare two rows
Date
Msg-id 20101012201747.GA720@tamu.edu
Whole thread Raw
In response to Re: default console user authentication?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: compare two rows
Re: compare two rows
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: default console user authentication?
Next
From: Tom Lane
Date:
Subject: Re: compare two rows