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