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
