show executed query in phpPgAdmin show executed query in phpPgAdmin postgresql postgresql

show executed query in phpPgAdmin


It's not possible with any currently released version of phpPgAdmin, although the feature could probably be added. You'd need to intercept the SQL being sent to the back-end, and then display this back out to the user. SQL execution is pretty well centralized, and if you look at the "history" feature you will see a way to trap/show queries, so munging those bits together would probably get you what you want. HTH, if someone implements this, please send a pull request!


As a quick dirty hack you could alter sources a bit to enable sql logging:In classes/database/ADODB_base.php in

function execute($sql) {...}

add these lines at the beginning:

global $misc;$misc->saveScriptHistory($sql);

This worked in my 5.0.3 version.