Re: compare two schemas - Mailing list pgsql-general

From Devrim GÜNDÜZ
Subject Re: compare two schemas
Date
Msg-id 1267958933.2305.4.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to compare two schemas  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
On Sun, 2010-03-07 at 16:40 +0600, AI Rumman wrote:
> I have to compare two schamas in two different Postgresql databases to
> identify the mismatch between the production and development
> environment
> databases.
>
> Is there any good tool?

http://bucardo.org/wiki/Check_postgres

check_postgres does this. See same_schema option.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Attachment

pgsql-general by date:

Previous
From: Adrian von Bidder
Date:
Subject: Re: non intuitive behaviour of DROP TABLE IF EXISTS
Next
From: Alban Hertroys
Date:
Subject: Re: XML Index again