From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Postgres Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | capturing and storing query statement with rules |
Date: | 2003-06-24 20:17:39 |
Message-ID: | 20030624201739.77120.qmail@web13403.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current datetime and the query statement. My thought
was to accomplish this by creating a rule that will
insert the information into a log table.
How can I captures the query statement so that I can
place it in a insert query? Is there a variable in
the server that holds the query statement as a string?
Am I about to go in over my head (again)?
Thanks,
Andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gould | 2003-06-24 20:25:07 | pg_dumping schemes (not schema) |
Previous Message | Jason Tishler | 2003-06-24 20:10:13 | Re: [HACKERS] ss_family in hba.c |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2003-06-24 20:20:18 | Re: Two weeks to feature freeze |
Previous Message | Jason Tishler | 2003-06-24 20:10:13 | Re: [HACKERS] ss_family in hba.c |