From: Robert Treat <xzilla@users.sourceforge.net>
To: pgsql-students@postgresql.org
Cc: oca@mvc.edu.ph
Subject: Re: Loggin a user who changed something in cetain table
Date: Fri, 01 Aug 2008 15:55:21 -0400
Message-ID: <200808011555.21627.xzilla@users.sourceforge.net> (raw)
In-Reply-To: <20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph>
References: <20080801062611.fhyb5515w0k4k00c@mail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-students@postgresql.org
Cc: xzilla@users.sourceforge.net, oca@mvc.edu.ph
Subject: Re: Loggin a user who changed something in cetain table
In-Reply-To: <200808011555.21627.xzilla@users.sourceforge.net>
References: <20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph> <200808011555.21627.xzilla@users.sourceforge.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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