| Lists: | pgsql-students |
|---|
| From: | oca(at)mvc(dot)edu(dot)ph |
|---|---|
| To: | pgsql-students(at)postgresql(dot)org |
| Subject: | Loggin a user who changed something in cetain table |
| Date: | 2008-07-31 22:26:11 |
| Message-ID: | 20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 사이트 순위SQL |
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
| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-students(at)postgresql(dot)org |
| Cc: | oca(at)mvc(dot)edu(dot)ph |
| Subject: | Re: Loggin a user who changed something in cetain table |
| Date: | 2008-08-01 19:55:21 |
| Message-ID: | 200808011555.21627.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-students |
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