pg.ddx.io pgsql-students@postgresql.org mailing list archive
help / color / mirror / Atom feedLoggin 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