| 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: | Whole Thread | Raw Message | 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 |