Re: Incremental Dump

"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