compare database

From: Sindu <software(at)dygsp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: compare database
Date: 2002-06-06 09:50:32
Message-ID: 20020606165032.A2828@top4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Is there any script to compare 2 database schema? (not the content, but
the structure).

I tried using "pg_dump -s" and comparing the resulting text file,
unfortunately it seems pg_dump is dumping the tables in OID order
(CMIIW), so the text file output might not be the same depending on the
table creation order.

I've searched the FAQ and contrib, and couldn't find any. I think this
should be in FAQ.

Thanks in advance and best regards,
Sindu

Browse pgsql-general by date

  From Date Subject
Next Message Giorgio Ponza 2002-06-06 10:47:39 Re: [ADMIN] performance issue using DBI
Previous Message Nicolas Nolst 2002-06-06 09:40:51 performance issue using DBI