[PostgresCompare](https://www.postgrescompare.com) 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. 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. ## 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](https://www.postgrescompare.com/downloads) - [Full release notes](https://www.postgrescompare.com/release-notes)
