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                                    

Reply via email to