From: | Dan99 <power919(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | audit sql queries |
Date: | 2007-09-09 23:13:31 |
Message-ID: | 1189379611.590865.244160@w3g2000hsg.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am working on auditing interactions with a pgsql database using
php. So my question is how can i go about obtaining the following
information by only being provided a pgsql query. I have asked this
same question in a php group however i would also like to ask it here
encase there is a way to do this entirely through postgres.
1. table(s) affected
2. column(s) affected
3. action performed on data (ie. update, insert, select, delete)
4. previous data for each row and column effected (if data changed or
deleted)
5. new data for each row and column effected (or existing data if data
is being selected)
Any help with this would be greatly appreciated.
Thanks,
Dan
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Maclean | 2007-09-09 23:37:04 | Re: replacing Access/ Approach etc |
Previous Message | Håkan Jacobsson | 2007-09-09 21:40:11 | Re: SQL for Deleting all duplicate entries |