| 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 |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | oca | 2008-08-09 14:15:06 | Problem accessing View in VB6 |
| Previous Message | oca | 2008-07-31 22:26:11 | Loggin a user who changed something in cetain table |