David,
> > Alternately, we can raise this on -Hackers and see what the
> > difficulty would be for hacking some of the libraries to either:
> >
> > 1) save all DDL statements to a log, or:
>
> This would actually be a super-groovy thing in general, 'cause the
> stuff pg_dump spits out, while useful from a reloading point of view,
> is a royal PITA from a reverse-engineering point of view. Ideally,
> DDL's would get logged in the precise state (ideally, with "--"'s
> included) that they were in before they got executed.
I think this would be relatively easy; in fact, I'm sure that Joe Conway could
do it. Why don't you give him a buzz?
--
Josh Berkus
Aglio Database Solutions
San Francisco