Redgate logo for print use

Redgate pgCompare

PostgreSQL schema comparison for faster, safer deployments

Stay in control of schema changes across dev, test, and production. Redgate pgCompare gives you a fast, reliable way to compare database schemas and deploy changes safely and efficiently.

Free trial

Viewing a diff between a source and target database in pgCompare

Whether you're syncing environments, fixing production issues, or preparing for release, pgCompare shows you exactly what changed and helps you deploy just what’s needed.

Community

Free for non-commercial use or small* businesses

Free download

*businesses with under $1 million in annual revenue and fewer than 250 employees.

Standard

$195 per user, per year

Why PostgreSQL users choose pgCompare

  • Line-level clarity

    See exactly what changed between two schemas

  • Speed and safety

    Generate deployment scripts in seconds – no manual scripting

  • Confidence in deployment

    Pre-deployment warnings flag risky changes

Viewing a schema comparison in Redgate pgCompare

Redgate’s schema comparison tools are used by 71% of the Fortune 100

Ideal for comparing and syncing PostgreSQL schemas in development workflows

Video thumbnail for Redgate pgCompare demo video

How it works

  1. Select two PostgreSQL databases or scripts to compare
  2. View schema differences side-by-side with detailed visual diff
  3. Generate accurate, dependency-aware SQL scripts
  4. Review, deploy, and confirm fixes – fast

Key features

  • Object-by-object comparison: Tables, views, functions, sequences, indexes, triggers, constraints, procedures, and more
  • Auto-generates SQL scripts that handle object dependencies
  • Provides warnings for risky operations like column drops or table truncations
  • Targeted deployment of specific objects
  • Visual diff interface
  • Supports PostgreSQL version 9 -latest
Reviewing a deployment script in Redgate pgCompare

Built for fast, safe PostgreSQL changes

With Redgate pgCompare, you can spot problems early, avoid downtime, and ship updates faster. Without risky full redeploys or tedious manual scripting.

Catch schema drift before it breaks things

Compare environments like dev, test, and production to instantly see what changed – and what didn’t

Fix production issues fast

Compare a live environment to a known-good version and deploy just the objects you need. No full rollback required.

Sync changes safely and quickly

Generate dependency-aware SQL scripts that respect object relationships and highlight risks like data loss or table drops.

Speed up releases

Validate and deploy schema changes in minutes, so you can keep shipping features without firefighting.

Improve collaboration across teams

Make handoffs easier by clearly showing what’s changed and why it matters.

Pricing and editions

If you'd like any help, or have a question about our tools or purchasing options, get in touch.

0800 169 7433
sales@red-gate.com

Community

Free for non-commercial use or small* businesses

Free download

*businesses with under $1 million in annual revenue and fewer than 250 employees.

Standard

$195 per user, per year

Need automation or CI/CD?

Redgate Flyway Enterprise offers automation and full CI/CD integration for PostgreSQL schema changes. It also supports other database types including SQL Server, Oracle, MySQL and more.

Learn more