On 2012-03-22, Martin Gregorie 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
Arvind Singh wrote:
> Help needed in parsing PostgreSQL CSV Log
[...]
> **However the main problem that is, the Log format is not readable**
> A Sample Log data line
> > 2012-03-21 11:59:20.640
>
IST,"postgres","stock_apals",3276,"localhost:1639",4f697540.ccc,10,"idle
",2012-03-21 11:59:20
> IST
On Thu, 2012-03-22 at 09:32 +, Arvind Singh wrote:
> Help needed in parsing PostgreSQL CSV Log
> Hello friends,
> I am working an a section of application which needs to Parse CSV Logs
> generated by PostgreSql server.
> - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log
> - The
Help needed in parsing PostgreSQL CSV Log
Hello friends,
I am working an a section of application which needs to Parse CSV Logs
generated by PostgreSql server.
- The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log
- The Server version in 9.0.4
- The application is developed in C Sharp
