Hi all,

Some of the char varying columns in my database have single quotations entered as hex 92. I would like to change them to Hex 27 because the COPY command chokes when it hits them in a psql script.

select name
from school
where name like '%' ||cast(x'92' as char) || '%'

does not work to select the rows I need.

Is there a way to do this in the database?

Thanks,

Jon

Maybe the replace function?