Re: log_destination = csvlog, line breaks interfere in analysis - Mailing list pgsql-general

From Albe Laurenz
Subject Re: log_destination = csvlog, line breaks interfere in analysis
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2086C1A25@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: log_destination = csvlog, line breaks interfere in analysis  (Craig Ringer <ringerc@ringerc.id.au>)
Responses Re: log_destination = csvlog, line breaks interfere in analysis
List pgsql-general
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,00000,"duração: 505.494 ms  executar
>> <unnamed>: select A, B
>>      from C join D
>>           on C.id = D.c_id
>>
>> And so on.

> Yick. That doesn't seem very CSV-like. I'm very surprised Pg isn't
> stripping newlines.

That's perfectly CVS-like.
The string is escaped with double quotes.
Double quotes in the query will be replaced with double double quotes.

So no CVS parser should have a problem with that.
I have tried it :^)

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: State of the art for foreign keys to child tables?
Next
From: Rafal Pietrak
Date:
Subject: Re: foreign key from array element