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@xxxxxxxxxx
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
