Thread: logging how to add timestamp
Postgresql: 8.4.x
How do you add a timestamp to the logs. Currently I see:
ERROR: {some error message}
STATEMENT: {the sql statement}
Ideally I would like to have the timestamp in front of the statements.
Thanks,
Lance Campbell
Software Architect/Project Manager/DBA
Web Services at Public Affairs
217.333.0382
http://illinois.edu/toolbox
On Wed, Jun 01, 2011 at 04:56:12PM +0000, Campbell, Lance wrote: > Postgresql: 8.4.x > How do you add a timestamp to the logs. Currently I see: > > ERROR: {some error message} > STATEMENT: {the sql statement} > > Ideally I would like to have the timestamp in front of the statements. > > Thanks, > > Lance Campbell > Software Architect/Project Manager/DBA > Web Services at Public Affairs > 217.333.0382 > http://illinois.edu/toolbox > log_line_prefix # %t = timestamp (no milliseconds) # %m = timestamp with milliseconds