I have a POSTGRESQL database that stores images in a bytea field. The data was imported incorrectly where an extra backslash ('') to the octal numeral. Below is a part of the bytea data stored in the database.

II*\\000\\010\\000\\000\\000\\023\\000\\376\\000\\004

I also included a screenshot of what I see below

The data should look something like this

II*\000\010\000\000\000\023\000\376\000\004

I have the SQL scripting with INSERT command, but the file is 250GB. I go down the path of modifying the INSERT script, I want to see if there is a way to remove the extract backslash, like using the REPLACE() function or anything like that to correct it?

Just trying to find out my options before I make a move.