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.
