|
|
Posted by Jerry Stuckle on 09/09/07 22:15
Dan99 wrote:
> 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 for by only being provided a pgsql query.
>
> 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
>
If you're presented with the query, you can parse it for the tables and
columns. You can also determine what the action is.
For the rest you would have to query the database itself - there's no
other way to get it in PHP.
Otherwise you need to check in a postgres group to see if that
information is available to you somewhere.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|