X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 993E7D1DF8B for ; Wed, 5 May 2004 13:07:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01354-10 for ; Wed, 5 May 2004 13:06:46 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 47595D1F12D for ; Wed, 5 May 2004 13:06:45 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i45GEUcM010011; Wed, 5 May 2004 12:14:30 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i45G6dl09721; Wed, 5 May 2004 12:06:40 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id JNFVGRNC; Wed, 5 May 2004 12:06:37 -0400 Subject: Re: Tool to compare db schemas? From: Robert Treat To: Chris Hoover Cc: pgsql-admin@postgresql.org In-Reply-To: <200405041337.01179.revoohc@sermonaudio.com> References: <200405041337.01179.revoohc@sermonaudio.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 05 May 2004 12:06:38 -0400 Message-Id: <1083773198.21180.464.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/46 X-Sequence-Number: 13362 On Tue, 2004-05-04 at 13:37, Chris Hoover wrote: > Does anyone know of a good tool to compare db schemas? I have over 200 db's > that should all have identical schemas and have been asked to report on the > differences. > http://pgdiff.sourceforge.net/ http://gborg.postgresql.org/project/pgdiff/projdisplay.php If you run across any others please lmk, I think I'm going to need this for a project in the next few days. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL