On Thursday 31 July 2008 18:26:11 oca(at)mvc(dot)edu(dot)ph wrote: > hi, > > how can i logged users activity in the table where he is manipulating > someting? > > like if i have a table: > > Table: charge_rates > Field1, Field2, Field3, user, time > > when a user login to postgre and manipulated (INSERT or UPDATE) > something on that table, is there a way that i can record it in that > table and specifically put the username on the record he changed? > http://pgfoundry.org/projects/tablelog/ http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html HTH -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL