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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
