Logging Question

------=_Part_6033_32897100.1203886651030
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi pgsql-novice:

I am using 8.3 and trying to build a log analyzer to take stats. I am
trying
to log the following:
Database Connection: Database Name, so I know which database its on
Statement: SELECT, INSERT, UPDATE, DELETE
Timestamp of Statement
Duration of statement (could be im****tant for performance tuning)

And most im****tant, I would like a record seperator, "<**** >", after each
log entry so my parser can know when to start and stop, for example:

<****>
foo_db: select * from some_table: Feb 21, 2008: 1s
<****>

Is this possible to do? Are there internal catalog command I can use
instead?

Any thoughts?

TIA

------=_Part_6033_32897100.1203886651030
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi pgsql-novice:<br><br>I am using 8.3 and trying to build a log analyzer
to take stats. I am trying to log the following:<br>Database Connection:
Database Name, so I know which database its on<br>
Statement: SELECT, INSERT, UPDATE, DELETE<br>Timestamp of
Statement<br>Duration of statement (could be im****tant for performance
tuning)<br><br>And most im****tant, I would like a record seperator,
&quot;&lt;**** &gt;&quot;, after each log entry so my parser can know when
to start and stop, for example:<br>
<br>&lt;****&gt;<br>foo_db: select * from some_table: Feb 21, 2008:
1s<br>&lt;****&gt;<br><br>Is this possible to do? Are there internal
catalog command I can use instead? <br><br>Any thoughts?<br><br>TIA<br> 

------=_Part_6033_32897100.1203886651030--