Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CFB4864FD3B for ; Fri, 1 Aug 2008 17:01:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58563-01-5 for ; Fri, 1 Aug 2008 17:01:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms173005pub.verizon.net (vms173005pub.verizon.net [206.46.173.5]) by postgresql.org (Postfix) with ESMTP id 50B526502A2 for ; Fri, 1 Aug 2008 17:01:50 -0300 (ADT) Received: from ridley.home ([71.179.100.114]) by vms173005.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K4X001VMU09UQQ4@vms173005.mailsrvcs.net> for pgsql-students@postgresql.org; Fri, 01 Aug 2008 14:55:22 -0500 (CDT) Date: Fri, 01 Aug 2008 15:55:21 -0400 From: Robert Treat Subject: Re: Loggin a user who changed something in cetain table In-reply-to: <20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph> To: pgsql-students@postgresql.org Cc: oca@mvc.edu.ph Message-id: <200808011555.21627.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph> User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/1 X-Sequence-Number: 119 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