I wrote a utility once at a company where I worked previously that did this.
It did compared the meta data tables of the the two schemas. This was in
Oracle though. I think it took me less than a week to do. It might be a nice
utility to build for postgres.
It started with code as
SELECT TABLE_NAME
FROM USER_TABLES
MINUS
SELECT TABLE_NAME
FROM USER_TABLES@XYZ
/
And vice versa.
It then compared columns of common tables, the characteristics of the
columns, the indexes etc and used PL/SQL.
Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"
www.UrbanaSoft.com
----- Original Message -----
From: "John Harrold" <jmh17@pitt.edu>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, July 22, 2003 11:46 AM
Subject: [GENERAL] comparing database schema's