Re: Comparing databases - Mailing list pgsql-novice

From Tom Lane
Subject Re: Comparing databases
Date
Msg-id 27885.1137011679@sss.pgh.pa.us
Whole thread Raw
In response to Comparing databases  ("Sugrue, Sean" <Sean.Sugrue@analog.com>)
Responses Re: Comparing databases  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-novice
"Sugrue, Sean" <Sean.Sugrue@analog.com> writes:
> Does anyone know how to structurally compare a list of tables
> between two different databases without going
> through them one by one?

You might try "pg_dump -s" on both databases and diff the output.
Not a perfect tool but it will serve for minor differences.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Sugrue, Sean"
Date:
Subject: Comparing databases
Next
From: Steve Tucknott
Date:
Subject: Open Office2