Hello > -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of ben.play > Sent: Mittwoch, 3. August 2016 15:29 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Log all queries before migration ? > > Hi guys, > > In fact, I would like to copy a table and then, when everything is finish, execute all inserts and updates since the > beginning of the copy. > > The biggest problem with the log at this time it's the query. > All my queries are not runnable.
> > When I log, I see this kind of queries : > "duration: 0.046 ms parse <unnamed>: UPDATE user SET money = money + $1 WHERE id = $2" > > But I would like to have only : "UPDATE user SET money = money + 100 WHERE id = 1281012" > > This is our postgresql.conf : > log_destination = 'csvlog' > logging_collector = on > log_min_duration_statement = 0 > log_statement = mod > log_directory = '/media/hdd/log_queries' > log_filename='log_insert.log' > log_file_mode = 0600 > log_error_verbosity = verbose > > > What do we have to change ? > > Thank you a lot for your help ! > > > > -- > View this message in context: http://postgresql.nabble.com/Log-all-queries-before-migration-tp5913922p5914599.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general