Postgres Pro
Downloads
Home   >   mailing lists

Re: Help in Parsing PG log usings CSV format - Mailing list pgsql-general

From Jasen Betts
Subject Re: Help in Parsing PG log usings CSV format
Date
Msg-id jkmhp3$f8n$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Help in Parsing PG log usings CSV format  (Arvind Singh <arvindps@hotmail.com>)
List pgsql-general
Tree view 
On 2012-03-22, Martin Gregorie <martin@gregorie.org> wrote:

> Thats fairly standard. A good CSV parser only requires a field to be
> quoted if it contains commas or quotes.

quotes,commas, or linebreaks

copy ( values (2,'comma, etc'),(3,'and "quote".'),(1,'line
break') ) to stdout with csv;

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: table alias for update
Next
From: Guillaume Lelarge
Date:
Subject: Re: can these queries be combined into one?