X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C905ED1C4C3 for ; Wed, 3 Mar 2004 03:40:46 +0000 (GMT) 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 58607-06 for ; Tue, 2 Mar 2004 23:40:46 -0400 (AST) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 81EB2D1BB7B for ; Tue, 2 Mar 2004 23:40:39 -0400 (AST) Received: from familyhealth.com.au (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id i233eVGi017966; Wed, 3 Mar 2004 11:40:32 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <404554A8.10905@familyhealth.com.au> Date: Wed, 03 Mar 2004 11:44:40 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Alex J. Avriette" Cc: Tom Lane , Mark Lubratt , pgsql-hackers@postgresql.org Subject: Re: [ADMIN] Schema comparisons References: <25377.1077942505@sss.pgh.pa.us> <4F7D4521-69BC-11D8-ACD3-000A9579AF50@indeq.com> <27965.1077982780@sss.pgh.pa.us> <20040229022348.GL8646@posixnap.net> In-Reply-To: <20040229022348.GL8646@posixnap.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/70 X-Sequence-Number: 50662 > I recently had to figure out what was different between the "live" schema > and the schema in cvs at work. This was a really painful process, and it > occurred to me that it wouldn't be terribly hard to write a perl program > to do it (I wound up using vim and diff). Is there interest in such a tool? > I could probably have one written within a day or two. Someone wrote a utility called 'pgdiff' that generated the SQL commands necessary to transform on db in to another IIRC. Chris