Date: Mon, 7 Mar 2005 17:09:14 +0200
From: Stef <svb@ucs.co.za>
To: John DeSoi <desoi@pgedit.com>
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Postgres schema comparison.
Message-ID: <20050307170914.51376f05@svb.ucs.co.za>
In-Reply-To: <F393FF18-8F05-11D9-A12B-000A95B03262@pgedit.com>
References: <20050307113312.2200b65c@svb.ucs.co.za>
	<F393FF18-8F05-11D9-A12B-000A95B03262@pgedit.com>
User-Agent: sillypheed-claws (anti-aliased)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

John DeSoi mentioned :
=> Develop a function that builds a string describing the tables/schemas 
=> you want to compare. Then have your function return the md5 sum of the 
=> string as the result. This will give you a 32 character value you can 
=> use to determine if there is a mismatch.

OK, this may be exactly what I need. I've compiled and installed contrib/pgcrypto
and I want to use either one of :
 Result data type | Schema |  Name  | Argument data types 
------------------+--------+--------+---------------------
 bytea            | public | digest | bytea, text
 bytea            | public | digest | text, text

Is it possible to somehow pass the output of : "\d [TABLE NAME]" 
to this function? If not, what would return me consistent text
that will describe the columns, indexes and primary keys of a table?

Kind Regards
Stefan