KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for PostgreSQL logo for PostgreSQL
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license

Compare view data

Open databases (see Schema changes summary use case) and 1click on Views:

for PostgreSQL, home tab click views

to open Object list tab with views. Note that rows highlight here is related only to view SQL definition changes and not related to data changes. Then 2click 'Compare data' for the required view, 3specify key fields combination and 4 click 'OK':

for PostgreSQL, object list click compare data and choose key

to open Data diff tab with result:

for PostgreSQL, data diff all records

Here you can 5apply filter to show only changed and/or new records:

for PostgreSQL, data diff new or changed records