Date: Tue, 8 Mar 2005 10:00:00 +0200
From: Stef <svb@ucs.co.za>
To: jim@contactbda.com
Cc: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
Message-ID: <20050308100000.64674fec@svb.ucs.co.za>
In-Reply-To: <20050307160942.M57950@contactbda.com>
References: <20050307113312.2200b65c@svb.ucs.co.za>
	<422C42B7.1030509@logix-tt.com>
	<20050307145444.459e54fe@svb.ucs.co.za>
	<22961.1110205853@sss.pgh.pa.us>
	<20050307173155.285dc2eb@svb.ucs.co.za>
	<20050307160942.M57950@contactbda.com>
User-Agent: sillypheed-claws (anti-aliased)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Jim Buttafuoco mentioned :
=> I use dblink to attach to both databases and query pg_namespace, pg_class, pg_attribute ... to get the diffs.  See
=> attached as an example.  look for the dblink_connect lines to specify your database.  You will need to install
=> contrib/dblink.  I used this with 7.4.X series and have NOT tested yet with 8.0.X.

Thanks!

This is something I haven't even thought of.
Only some of the machines have dblink installed at the moment,
but that's the same work as having to install pgcrypto everywhere.

This is actually more thorough. It seems to be working with some minor changes on 7.3
(The dblink functions don't allow multiple connections, and take only one argument, so
I created temp tables in stead). This is actually very fast.

Thanks again.

Kind Regards
Stefan