Re: logging as inserts

Josh,

> >>I am looking at having one of our guys write up the code to allow
> >>logging as insert statements. I have a couple of questions.
> >>
> >>What would we like the postgresql.conf option to be? I was thinking
> >>log_statements_as_inserts = (t/f)

Nope.   

log_destination = 'inserts'   #not a new GUC!

insert_columns = '%u,%d,%r,%p, ... %$'
#this new GUC would define a list of comma-seperated columns as escape codes 
defined via the same code set as log_line_prefix.   The only change would be 
the addition of %$, which would symbolize the "statement" being logged.

I'd also assert that this option should log the inserts to a "stderr" and thus 
take advantage of all of the redirection, rotation, etc that we now support 
for stderr logging.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco