Re: Postgres schema comparison.

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