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
* The basic utility after Parse the Log is to show contents in a DataGridView.
* There are other filter options like to view log contents for a particular range of Time for a Day.
**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,2/163,0,LOG,00000,"statement: SELECT version()",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""
As you can see the columns in the Log are comma separated , But however individual values are not Quote Enclosed.
For instance the 1st,4rth,6th .. columns
**Is there a setting in PostgreSQL configuration to place quotes around all columns in a Logfili
I just want to update the columns so that all are within Quotes
what happens wrong is when it reaches the column where sql statement is place. it also has commas set for table columns. The log line is a mix bunch of quote-enclosed and non-quote-enclosed column. is there is a configuration or utility to convert the non-quoted column to quoted column
PS : the copy utility or any other utility cannot be used , as we have to parse the log within a C Sharp application
Thanks for any advice and help