mysqldiff-like utility for PG?

From: adwolf1(at)yahoo(dot)com (ad wolf)
To: pgsql-admin(at)postgresql(dot)org
Subject: mysqldiff-like utility for PG?
Date: 2002-08-16 02:43:19
Message-ID: 5580cd6f.0208151843.52ff6467@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there any utility like mysqldiff
(http://adamspiers.org/computing/mysqldiff/) for PG?

"mysqldiff is a Perl script which compares the data structures (i.e.
table definitions) of two MySQL databases, and returns the differences
as a sequence of MySQL commands suitable for piping into mysql which
will transform the structure of the first database to be identical to
that of the second (c.f. diff and patch). Database structures can be
compared whether they are files containing table definitions or
existing databases, local or remote. "

It would make our lives 1000x easier if such a tool existed. As it
stands now, the process of updating the DB involves manually writing a
series of alter statements, which is a huge pain. I can't be the only
one with this problem!

Any and all help is appreciated. Thanks.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Elielson Fontanezi 2002-08-16 12:08:51 DAO for Postgres
Previous Message Sub Director Sistemas Informaticos 2002-08-15 21:24:17 Can I get the users list straight from the system ?