PostgresCompare is pleased to announce the release of version 1.1.104, along with a summary of recent highlights from 1.1.103.
PostgresCompare connects to two live PostgreSQL databases, detects schema differences across tables, views, functions, indexes, types, and 30+ other object types, and generates a ready-to-run SQL deployment script to synchronise them. It runs on Windows, macOS, and Linux.
Pre/post deploy scripts — Projects can now include custom SQL that runs before or after the generated deployment script. Useful for pre-flight checks, disabling triggers, setting session variables, or post-deployment verification. Both editors use Monaco with full SQL syntax highlighting and scripts are saved with the project.
Global search — A new search bar lets users find projects, environments, and comparison objects from anywhere in the application. Results are grouped by type and update as you type.
Keyboard navigation — The difference list now supports up/down arrow key navigation, making it faster to move through a large set of differences without the mouse.
Dependency cascade selection — Selecting a script statement automatically selects any statements it depends on, preventing incomplete deployments caused by missing dependencies.
Redesigned comparison card — The comparison summary card now includes progress bars and a breakdown of difference types for a clearer at-a-glance view of what changed.
Destructive change warnings — Deployment scripts now classify every statement by risk level before you run them. Destructive statements (e.g. DROP TABLE, DROP COLUMN) are highlighted in red, warning-level statements (e.g. DROP FUNCTION, DROP VIEW) in amber, with icons and glyph markers in the SQL editor. A summary banner shows the total count so nothing is missed.
Hover to preview differences — Hovering over any row in the statement list shows a floating diff popover with the before and after SQL side-by-side, without leaving the script screen.
Deployment script section headers — Generated scripts now group statements by object type (Tables, Views, Functions, Indexes, etc.) with clickable section headers in the statement list. A script header records the version, source and target database names, and timestamp.
PostgresCompare 1.1.104 is available for Windows, macOS, and Linux. A 30-day free trial is available with no credit card required. PostgreSQL versions 9.2 through 18 are supported.