pgsql-announce
❮
PostgresCompare 1.1.104 Released
- Jump to comment-1PostgresCompare via PostgreSQL Announce<announce-noreply@postgresql.org>Feb 26, 2026, 7:51 AM UTCPostgresCompare 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.
## New in 1.1.104
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.
## Recent Highlights from 1.1.103
Destructive change warnings — Deployment scripts now classify every
statement by risk level before you run them. Destructive statements (e.g.
Hover to preview differences — Hovering over any row in the statementDROP 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.
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.
## Availability
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.
- Download PostgresCompare 1.1.104
- Full release notes