Re: Incremental Dump - Mailing list pgsql-novice

From Tom Lane
Subject Re: Incremental Dump
Date
Msg-id 23915.1056635564@sss.pgh.pa.us
Whole thread Raw
In response to Incremental Dump  ("Herbie McDuck" <herbie@faams.net>)
Responses Re: Incremental Dump  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
"Herbie McDuck" <herbie@faams.net> writes:
> Is there a proceedure to allow one to compare the database structure of a
> deployed database against a developmenmt database to note any structural
> change in one or more tables?

I'd try pg_dump -s (schema only) and diff the two dumps.  You might have
to do some fooling around if objects were created in different orders in
the two databases, though, since that would affect the dump order.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Herbie McDuck"
Date:
Subject: Incremental Dump
Next
From: "Herbie McDuck"
Date:
Subject: Re: Incremental Dump