---

layout: landing

title: Compare PostgreSQL Schemas, Postgres Diff Tool

excerpt: Postgres Compare compares PostgreSQL database schema objects and writes the SQL to deploy the differences. An accurate and easy to use diff tool for Postgres.

---

<section id="banner">

<h1>Compare PostgreSQL Databases</h1>

<p>The PostgreSQL comparison and deployment tool you've been looking for.<br/>

<a href="/downloads">Download</a> now and try it for free.</p>

<form action="https://postgrescompare.us13.list-manage.com/subscribe/post?u=7ef8a41f90e25826ea5b3d5fc&amp;id=14d2217fd9" method="post" id="mc-embedded-subscribe-form" name="mc-embedded-subscribe-form" class="validate" novalidate>

<div class="row uniform 50%">

<div class="8u 12u(mobilep)">

<input type="email" value="" name="EMAIL" class="email" placeholder="Email Address" required>

<div style="position: absolute; left: -5000px;" aria-hidden="true"><input type="text" name="b_7ef8a41f90e25826ea5b3d5fc_14d2217fd9" tabindex="-1" value=""></div>

</div>

<div class="4u 12u(mobilep)">

<input type="submit" value="Sign Up" name="subscribe" class="fit">

</div>

</div>

<div>

</form>

<section id="main" class="container">

<section class="box special">

<header class="major">

<h2>Diff PostgreSQL schemas.<br/> Find differences and deploy changes quickly.</h2>

</header>

<iframe width="560" height="315" src="https://www.youtube.com/embed/yc0i6Dx-Wu4" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>

<p>Postgres Compare is a Postgres diff tool that automatically detects the changes made to your database and produces the SQL required to keep everything up to date. Increase visibility, reduce errors and save time with Postgres Compare.</p>

</section>

<section id="learn-more" class="box special features">

<div class="features-row">

<section>

<span class="icon major fa-compress accent2"></span>

<h3>Diff Database and Schema Objects</h3>

<p>Compare between live databases or snapshots from a point in time. Postgres Compare diffs the system catalogs and shows you where objects have been added, removed or changed.</p>

</section>

<section>

<span class="icon major fa-check accent3"></span>

<h3>SQL Migration Scripts</h3>

<p>Automatically write the SQL you need to deploy changes between environments. Postgres Compare helps ensure you include dependent objects and warns you of any destructive changes you might make.</p>

</section>

</div>

<div class="features-row">

<section>

<span class="icon major fa-bug accent4"></span>

<h3>Test</h3>

<p>Test your migration scripts on demand. One click will spin up a clone of the target database, run the migration script and report any issues encountered.</p>

</section>

<section>

<span class="icon major fa-bar-chart accent5"></span>

<h3>Reports</h3>

<p>Create beautiful reports to illustrate the state of your environments. Store and share reports via your Postgres Compare account.</p>

</section>

</div>

</section>

<div class="box special row">

<div class="6u 12u(narrower)">

<h3>Diff and Deploy Objects</h3>

<table style="text-align: left;">

<tr>

<td><span class="icon fa-check"></span></td>

<td>Tables and Columns</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Constraints</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Indexes</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Views</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Data types and Domains</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Functions, Triggers, Operators and Rules</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Users and Roles</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Schemas</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Database and Server configuration</td>

</tr>

</table>

</div>

<div class="6u 12u(narrower)">

<h3>Features</h3>

<table style="text-align: left;">

<tr>

<td><span class="icon fa-check"></span></td>

<td>Manage multiple servers</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Compare at the database, schema or object level</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Create, save and execute SQL change scripts</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Continuous integration support with the command line</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Store snapshots to work offline or backup</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Deployment warnings and dependency analysis</td>

</tr>

<tr>

<td><span class="icon fa-check"></span></td>

<td>Powerful filters to exclude objects by type, name or difference type</td>

</tr>

<tr>

<td><span class="icon fa-arrow-right"></span></td>

<td><a href="/contact">Let us know what <em>you</em> need from Postgres Compare...</a></td>

</tr>

</table>

</div>

</div>

<div class="row">

<div class="6u 12u(narrower)">

<section class="box special">

<span class="image featured"><img src="images/pic02.jpg" alt="Compare Postgresql databases on your desktop" /></span>

<h3>On Linux, MacOS and Windows</h3>

<p>Postgres Compare goes where you go, so it's ready to work with your database environments straight away. It's cross platform too!</p>

<ul class="actions">

<li><a href="#cta" class="button alt">Learn More</a></li>

</ul>

</section>

</div>

<div class="6u 12u(narrower)">

<section class="box special">

<span class="image featured"><img src="images/pic03.jpg" alt="Postgres diff tool that runs on the web" /></span>

<h3>On the web</h3>

<p>Log in to your Postgres Compare account to enable cloud features. Share reports, upload snapshots and test your deployment scripts on demand.</p>

<ul class="actions">

<li><a href="#cta" class="button alt">Learn More</a></li>

</ul>

</section>

</div>

<section>

<header class="major">

<h2>How does Postgres Compare compare?</h2>

</header>

<p>

PostgreSQL's system catalogs store everything there is to know about the server and the structures contained in its databases.

Postgres Compare uses the system catalogs to determine the changes that have been made. The differences produce the CREATE, ALTER

and DELETE SQL that ensure the database is up to date.

</p>

<p>

Postgres Compare takes a snapshot of the server and stores it locally so you can easily keep track of changes or compare against old versions.

Connections, comparisons and deployment scripts too are stored for re-use and reporting purposes.

</p>

<p>

As an example imagine you have changed the datatype of a column in your test environment. Postgres Compare looks at the

<a href="https://www.postgresql.org/docs/current/static/catalog-pg-attribute.html">pg_attribute system catalog</a> and detects that the column has been changed compared to production.

You go ahead and generate a deployment script that saves you time and ensures you don't miss anything!

<pre>ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);</pre>

</p>

</section> </div>

<section id="cta">

<h2>Sign up for updates</h2>

<p>We don't do unsolicited emails, just useful updates and invitations to try Postgres Compare.</p>

<form action="https://postgrescompare.us13.list-manage.com/subscribe/post?u=7ef8a41f90e25826ea5b3d5fc&amp;id=14d2217fd9" method="post" id="mc-embedded-subscribe-form" name="mc-embedded-subscribe-form" class="validate" novalidate>

<div class="row uniform 50%">

<div class="8u 12u(mobilep)">

<input type="email" value="" name="EMAIL" class="email" placeholder="Email Address" required>

<div style="position: absolute; left: -5000px;" aria-hidden="true"><input type="text" name="b_7ef8a41f90e25826ea5b3d5fc_14d2217fd9" tabindex="-1" value=""></div>

</div>

<div class="4u 12u(mobilep)">

<input type="submit" value="Sign Up" name="subscribe" class="fit">

</div>

</div>

<div>

</form>

<script type="application/ld+json">

{

"@context": "http://schema.org/",

"@type": "Product",

"name": "Postgres Compare",

"image": "https://www.postgrescompare.com/images/1469427963_009_053_animal_elephant_bishop_mammal.png",

"logo": "https://www.postgrescompare.com/images/1469427963_009_053_animal_elephant_bishop_mammal.png",

"description": "Postgres Compare compares PostgreSQL database schema objects and writes the SQL to deploy the differences. An accurate and easy to use diff tool for Postgres.",

"brand": {

"@type": "Thing",

"name": "Postgres Compare"

}

}

<script type="application/ld+json">

{

"@context": "http://schema.org",

"@type": "Organization",

"name": "Postgres Compare",

"telephone": "437-888-2339",

"email": "[email protected]",

"address": {

"@type": "PostalAddress",

"addressLocality": "Toronto, Canada",

"postalCode": "M6S0A1",

"streetAddress": "1 Old Mill Drive"

},

"url": "https://www.postgrescompare.com",

"logo": "https://www.postgrescompare.com/images/1469427963_009_053_animal_elephant_bishop_mammal.png",

"description": "Postgres Compare compares PostgreSQL database schema objects and writes the SQL to deploy the differences. An accurate and easy to use diff tool for Postgres.",

"sameAs": [

"https://www.facebook.com/postgrescompare",

"https://www.twitter.com/postgrescompare",

"https://www.linkedin.com/company/postgres-compare",

"https://www.google.com/+PostgresCompare",

"https://github.com/PostgresCompare"

]

}