Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-18 Thread Edson Richter
Em 18/09/2012 04:13, Albe Laurenz escreveu: Craig Ringer wrote: On 09/18/2012 03:21 AM, Edson Richter wrote: 2012-09-17 14:25:33.150 BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15 16:14:51 BRT,10/204822,0,LOG,0,"duração: 505.494 ms executar : select A, B

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-18 Thread Albe Laurenz
Craig Ringer wrote: > On 09/18/2012 03:21 AM, Edson Richter wrote: >> 2012-09-17 14:25:33.150 >> BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15 >> 16:14:51 BRT,10/204822,0,LOG,0,"duração: 505.494 ms executar >> : select A, B >> from C join D >>

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-17 Thread Craig Ringer
On 09/18/2012 03:21 AM, Edson Richter wrote: 2012-09-17 14:25:33.150 BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15 16:14:51 BRT,10/204822,0,LOG,0,"duração: 505.494 ms executar : select A, B from C join D on C.id = D.c_id And so on. Yick.

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-17 Thread Edson Richter
... Sorry, by mistake I've duplicated the mail. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-17 Thread Edson Richter
Dear all, I've started collecting log information in CSV format, but I need a way to customize it. Problem is that I'm collecting slow statements, and the statements have \n (newline) character, and the piece of 2012-09-17 14:25:33.150 BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d