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,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 :^)
Yes, after testing with Apache OpenOffice 3.4.1, I see that it has been
correctly interpreted.
I'll post a bug request at Microsoft so they may (or may not) fix Excel
csv importer.
Regards,
Edson.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
