Comparing database schema's

From: Frank Kurzawa <fkurzawa(at)topazsoftware(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Comparing database schema's
Date: 2004-08-02 22:04:07
Message-ID: 1091484247.5419.93.camel@zaza.aus.topazsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How are people doing automated comparisons of schemas in different databases?

E.g. we have a dev database, a beta database, and a production database. We
need to insure that changes in schema are propagated properly during the
development and deployment process.

I've experimented some with 'pg_dump -s' to do this: Do a schema dump on the two
databases and a diff. But due to myriad small differences (order of creation
of tables, constraints, etc.) it is very difficult to get a usable diff without
engaging in massive massage of the dump output, including dumping a table at a time.

I found a reference to a schema comparison tool in the mailing list archives, but
it appears to be far out of date and not currently supported.

Regards,

Frank

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Gaetano Mendola 2004-08-02 22:19:22 Re: Comparing database schema's
Previous Message Si Chen 2004-08-02 18:26:35 inserting multiple rows