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



view thread (2+ messages)

Message-ID: <200808011555.21627.xzilla@users.sourceforge.net>
Permalink:  ../200808011555.21627.xzilla@users.sourceforge.net/
Also on:    postgresql.org/message-id/200808011555.21627.xzilla@users.sourceforge.net

 · 

reply

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