From: Stef <svb@ucs.co.za>
To: jim@contactbda.com
Cc: pgsql-sql@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
Date: Tue, 8 Mar 2005 10:00:00 +0200
Message-ID: <20050308100000.64674fec@svb.ucs.co.za> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: svb@ucs.co.za, jim@contactbda.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
In-Reply-To: <20050308100000.64674fec@svb.ucs.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox