compare two schemas

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