I want to compare views across two PostGreSQL databases. The views, of course, don't have primary keys—you can't assign a primary key to a view in PostGreSQL, for good reason. Since there are some rows which are duplicates, I can't just select all the columns as the primary keys—I get an error saying that there are duplicate keys.
The order of rows in the views is determined by the queries and the tables they pull from. So why can't the "Compare Table Data" just diff the two row-by-row without needing a primary key?
This is the reason I downloaded DB Solo, but it looks like it won't work for my purposes.
Thanks,
Matt