Re: [SQL] Postgres schema comparison. - Mailing list pgsql-admin

From Tom Lane
Subject Re: [SQL] Postgres schema comparison.
Date
Msg-id 22961.1110205853@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Postgres schema comparison.  (Stef <svb@ucs.co.za>)
Responses Re: [SQL] Postgres schema comparison.  (Stef <svb@ucs.co.za>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help on maintaining pgsql/data folder size
Next
From: Tom Lane
Date:
Subject: Re: Build from file syntax troublem (part II).