Re: Schema migration tools?

On Apr 22, 2008, at 4:33 PM, John DeSoi wrote:

>
> 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?

Right. It's not something you'd want to lift directly and run
somewhere else.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com