log_destination = csvlog, line breaks interfere in analysis

Поиск
Список
Период
Сортировка
От Edson Richter
Тема log_destination = csvlog, line breaks interfere in analysis
Дата
Msg-id BLU0-SMTP25355EAFE3BD093B15E70AFCF950@phx.gbl
обсуждение исходный текст
Ответы Re: log_destination = csvlog, line breaks interfere in analysis
Re: log_destination = csvlog, line breaks interfere in analysis
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Richter
Дата:
Сообщение: log_destination = csvlog
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: Official C++ API for postgresql?