I cannot seem to change
I have tried this method:
ALTER DATABASE dbname SET bytea_output TO 'hex';
I have tried to edit postgresql.conf
bytea_output = 'hex'
and restarted the server.
I have tried
SET bytea_output = 'hex'
and it works per transaction, but that is very tedious.
However, whenever I browse my bytea columns in phpPgAdmin, the columns are outputted escaped.
SELECT setting FROM pg_settings WHERE name = 'bytea_output'
bytea_output be set permanently to