log_destination = csvlog, line breaks interfere in analysis

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: log_destination = csvlog, line breaks interfere in analysis
Date: 2012-09-17 19:21:04
Message-ID: BLU0-SMTP25355EAFE3BD093B15E70AFCF950@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.3d2c,1,"SELECT",2012-09-15
16:14:51 BRT,10/204822,0,LOG,00000,"duração: 505.494 ms executar
<unnamed>: select A, B
from C join D
on C.id = D.c_id

And so on.

It's not possible to change the application (hours of testing after
changes will not be feasible for 2 million LOC).

How can I tell PostgreSQL that it should remove the line breaks (and
change them into whitespace character) from SQL statements? Or there is
an "regexp" I can use for this purpose?

Thanks,

Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2012-09-17 19:22:42 Re: Official C++ API for postgresql?
Previous Message Edson Richter 2012-09-17 19:20:14 log_destination = csvlog