Loggin a user who changed something in cetain table

From: oca(at)mvc(dot)edu(dot)ph
To: pgsql-students(at)postgresql(dot)org
Subject: Loggin a user who changed something in cetain table
Date: 2008-07-31 22:26:11
Message-ID: 20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-students by date

  From Date Subject
Next Message Robert Treat 2008-08-01 19:55:21 Re: Loggin a user who changed something in cetain table
Previous Message Kunal Gupta 2008-07-17 20:29:22 How to connect to EC2 from postgres using stored procedure plpythonu