X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8C99A56458;
	Mon,  7 Mar 2005 15:22:21 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 90197-07; Mon,  7 Mar 2005 15:22:13 +0000 (GMT)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 2758356422;
	Mon,  7 Mar 2005 15:22:07 +0000 (GMT)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 5B7BE2BD51;
	Mon,  7 Mar 2005 17:22:06 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP
	id F3B66D9F2C; Mon,  7 Mar 2005 17:22:04 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with ESMTP id 9B481973EC;
	Mon,  7 Mar 2005 17:22:06 +0200 (SAST)
Date: Mon, 7 Mar 2005 17:22:06 +0200
From: Stef <svb@ucs.co.za>
To: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
Message-ID: <20050307172206.3201ccb3@svb.ucs.co.za>
In-Reply-To: <422C51DC.5050408@logix-tt.com>
References: <20050307113312.2200b65c@svb.ucs.co.za>
	<422C42B7.1030509@logix-tt.com>
	<20050307145444.459e54fe@svb.ucs.co.za>
	<422C51DC.5050408@logix-tt.com>
X-Mailer: Sylpheed-Claws 1.0.1 (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YE<S+T;
	pGztI>WH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.328 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_WHOIS
X-Spam-Level: 
X-Archive-Number: 200503/86
X-Sequence-Number: 16584

Markus Schaber mentioned :
=> Some weeks ago, I posted here a script that uses psql to create split
=> dumps. Maybe you can reuse some of its logics to create per-table
=> md5sums for all tables in a database automatically.


Thanks, but I've got something very similar to this already. I almost
thought you managed to split the output of the single schema dump of 
"pg_dump --schema-only" onto portions belonging to the various tables.
That would be very impressive :)

Kind Regards
Stefan