Postgres Pro
Downloads
Home   >   mailing lists

Loggin a user who changed something in cetain table - Mailing list pgsql-students

From oca@mvc.edu.ph
Subject Loggin a user who changed something in cetain table
Date
Msg-id 20080801062611.fhyb5515w0k4k00c@mail.mvc.edu.ph
Whole thread Raw
Responses Re: Loggin a user who changed something in cetain table  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-students
Tree view 
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

pgsql-students by date:

Previous
From: "Kunal Gupta"
Date:
Subject: How to connect to EC2 from postgres using stored procedure plpythonu
Next
From: Robert Treat
Date:
Subject: Re: Loggin a user who changed something in cetain table