pg.ddx.io  pgsql-students@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Loggin a user who changed something in cetain table
2+ messages / 2 participants
[nested] [flat]

* Loggin a user who changed something in cetain table
@ 2008-07-31 22:26 oca@mvc.edu.ph
  2008-08-01 19:55 ` Re: Loggin a user who changed something in cetain table Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 1 reply; 2+ messages in thread

From: oca@mvc.edu.ph @ 2008-07-31 22:26 UTC (permalink / raw)
  To: pgsql-students

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







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Loggin a user who changed something in cetain table
  2008-07-31 22:26 Loggin a user who changed something in cetain table oca@mvc.edu.ph
@ 2008-08-01 19:55 ` Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Treat @ 2008-08-01 19:55 UTC (permalink / raw)
  To: pgsql-students; +Cc: oca@mvc.edu.ph

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-08-01 19:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-31 22:26 Loggin a user who changed something in cetain table oca@mvc.edu.ph
2008-08-01 19:55 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox