The attached patch implements SQL command history for
phpPgAdmin. The patch is against the current CVS head
and should be applied in the root directory with:
zcat history.patch.gz | patch -p0
To use the new history functionality, a table needs to
be created in the phpPgAdmin database using the file
sql/history-pgsql.sql script. Also several values from
the patched conf/config.inc.php-dist file need to be added.
We use phpPgAdmin a lot for database maintenance and
found the only thing lacking for us was the ability to
execute historical commands. We coded this patch and
have been using it for several months without incident.
Note: The patch actually contains three functionality
enhancements:
1. Command History.
2. User defined SQL command window size as defined in
config.inc.php
3. SQL syntax highliter using the GeSHi syntax
highliter. The postgresql module for GeSHi was created
from a generic SQL module and modified for PostgreSQL.
It probably still needs more refinement.
Logged In: YES
user_id=32581
Hmm, don't know what happened to the patch so here it is.
Patch to add history to phpPgAdmin