Re: Comparing database schema's

Frank Kurzawa wrote:

> 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.

Consider to use the EMS tool postgres comparer:

http://www.ems-hitech.com/pgsqlutils/

Regards
Gaetano Mendola