Thread: Loggin a user who changed something in cetain table

Loggin a user who changed something in cetain table

From

oca@mvc.edu.ph

Date:

31 July 2008, 22:33:58

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?

Thank you,
oca

Re: Loggin a user who changed something in cetain table

From

Robert Treat

Date:

01 August 2008, 20:01:54

On Thursday 31 July 2008 18:26:11 oca@mvc.edu.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