From: Stef <svb@ucs.co.za>
To: John DeSoi <desoi@pgedit.com>
Cc: pgsql-ADMIN@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres schema comparison.
Date: Mon, 7 Mar 2005 17:09:14 +0200
Message-ID: <20050307170914.51376f05@svb.ucs.co.za> (raw)
In-Reply-To: <F393FF18-8F05-11D9-A12B-000A95B03262@pgedit.com>
References: <20050307113312.2200b65c@svb.ucs.co.za>
<F393FF18-8F05-11D9-A12B-000A95B03262@pgedit.com>
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
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, desoi@pgedit.com, pgsql-ADMIN@postgresql.org
Subject: Re: Postgres schema comparison.
In-Reply-To: <20050307170914.51376f05@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