Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-students by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group