Re: Easiest way to compare the results of two queries row by row and column by column

I'd run:

select * from v_old 

except

select * from v_new ;

And then 

select * from v_new

except

select * from v_old ;

Both should return no rows.

However, if the queries can contain duplicate rows this will not detect differences in the number of times a row is replicated, i.e. if one query has a row 2 times and the other has it 3 times.  If you need to detect such cases, I'd probably \copy out each query to a file, then use system tools to sort and diff the files.

Cheers,

Jeff