Stef <svb@ucs.co.za> writes:
> Markus Schaber mentioned :
> => But maybe a pg_dump --schema-only on all the databases, and then
> => manually diffing the files may already fulfil your needs.
> I've tested something similar, that seems to work ok for me for now :
> pg_dump -s -t [TABLE] [DBNAME] | grep -v "^--" | md5sum
> The problem I have with this, is that I have to run the command per table,
Why?
If the problem is varying order of table declarations, try 8.0's
pg_dump.
regards, tom lane