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 [EMAIL PROTECTED]
/
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 11:46 AM
Subject: [GENERAL] comparing database schema's
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
