On 18/09/12 08:45, Edson Richter wrote:
Em 17/09/2012 16:32, Ryan Kelly escreveu:
On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote:
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?
CSV parsers should handle this correctly. What tools are you trying to
use?
Thanks,
Edson
-Ryan Kelly
Actually, tried with Apache OpenOffice 3.4.1, and it works as
expected. So, I just kicked Excel and now using OO.
Regards,
Edson.
Try LibreOffice, as it has replaced OpenOffice for most practical purposes!
LibreOffice is up to version 3.6.1 with 3.6.2 out Real Soon Now
(probably in a couple of weeks), it has many bug fixes, enhancements,
and performance improvements over OpenOffice 3.4.1.
http://www.libreoffice.org/
Cheers,
Gavin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
