Re: Schema migration tools?

On Apr 22, 2008, at 4:53 PM, Erik Jones wrote:

>> It would be nice if PostgreSQL had some kind of unique reference
>> for the column, but I think columns are just numbered sequentially
>> as they are added. It would also be neat to have a built-in way to
>> log the schema changes.
>
> It does: log_statement set to either 'all' or 'ddl' will do the trick.

If I do this, is there a way to get a transaction consistent log of
just the necessary commands to transform another copy of the database?
In other words, I assume this approach will log each DDL command even
if the transaction is rolled back. Correct?

Thanks,



John DeSoi, Ph.D.