Products
- Database Tools
  
  Must-have tools for database development, data analysis, data management, and server administration
  
  SQL Server Tools
  
  MySQL Tools
  
  Oracle Tools
  
  PostgreSQL Tools
  
  Data Connectivity
  
  Wide choice of world-class data connectivity solutions for various data connection technologies and frameworks
  
  ADO.NET Data Providers
  
  ODBC Drivers
  
  SSIS Components
  
  Excel Add-ins
  
  Delphi Data Components
  
  dbExpress Drivers
  
  Productivity Tools
  
  Tools that help developers to write code, conduct code reviews, compare sources, track the working time, and much more
  
  Coding Assistance Tools
  
  ORM Solutions
  
  Time Tracking App
  
  Data Services
  
  All-in-one cloud data platform for no coding data integration, data access, cloud to cloud backup, and management
  
  Data Integration Services
  
  Cloud to Cloud Backup
  
  Online SQL Tools
  
  OData Server
  All Products Free Products
Store
Support
- Tech support
  
  Questions or problems? Our dedicated support teams can answer product related questions.
  
  Request Support
  
  Documentation Center
  
  Forums
  
  Using Website
  
  Sales support
  
  Answers to all common questions that you might have and a bit more.
  
  Ordering FAQ
Blog
Company
- About us
  
  Learn more about the company, people, vision, and history
  
  About us
  
  Customers
  
  Partners
  
  Resellers
  
  Contacts
  
  Resources
  
  Get updated with the latest worldwide events.
  
  Events
  
  Community
  
  Join our community of technology experts. Learn something new or share your experience with a wide audience.
  
  CodingSight

Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Learn more

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Learn more

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Learn more

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

Learn more

Compare Diffs and Sync Table Data in PostgreSQL

dbForge Data Compare for PostgreSQL is a tool for table data comparison and synchronization. When using our PostgreSQL data compare tool you can detect data differences in compared PostgreSQL tables. You can also generate data synchronization script and execute it to eliminate all these differences.

Using our diff tool you can:

Identify the differences between two databases
Compare separate tables or table groups by table name mask
Compare tables with different structure
Generate a report embodying data diff and save it for further analysis

Sync data in tables and views in full or in part
Generate SQL script for database synchronization
Organize database synchronization according to the schedule

Explore the differences between two databases

Comparison results are displayed in a convenient UI, easy for review differences, and further analysis and synchronization. You can select what objects to show: objects with different or identical records, and how they will be shown - only in source or only in target records.

Compare tables with different structure

The tool automatically maps objects that you want to compare: tables, views, columns, and schemas. You can change the default mapping to map tables with different names and structure.

Custom query comparison

You can compare an actual table with its query result. You may also specify a WHERE clause expression to prevent undesired rows being compared.

Generate comparison report

dbForge Data Compare for PostgreSQL provides a possibility to view results of data comparison in the form of a report. You can choose a form of a report: Excel or HTML, and also select objects you want to report.

Synchronize table data fully or partly

Just select the data to synchronize in the grid with comparison results. Set output options to manage synchronization script and click synchronize. The synchronization script will appear in a split second.

Generate synchronization script

dbForge Data Compare for PostgreSQL automatically generates errorless synchronization script. You can execute generated script to synchronize databases, or save the script to a file.

Schedule database comparison

You can use Windows Task Scheduler to create and manage synchronization tasks that your computer will carry out automatically at the times you specify.