You can use SchemaCrawler, a free open-source tool that can compare schemas as well as data. SchemaCrawler is a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema.
http://schemacrawler.sourceforge.net/ Sualeh Fatehi. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org