G'day. One of my clients is using phpPgAdmin to
manage a database with tables that include bytea
This works ok for display, but doesn't correctly
format the bytea data on the way back into the
I have been able to resolve this, against the version
in our current distribution (3.5.5), and I did verify
that the problem still exists in the most current
release on SF.net.
The changes required were quite minimal:
in function 'printField', include the '\' character in
the list of character to escape with 'addCSlashes'.
in the function 'formatValue', add handling for bytea
$value = stripcslashes($value);
$value = pg_escape_bytea($value);
Including the '\' character in the initial escaping is
necessary for reversing the process later.
I hope that helps. Feel free to let me know if you
need more advice or information on this.