Ubuntu – How to replace surrogate code point characters with regex_replace in postgres
My requirement is to strip surrogate code point characters from a Postgres column, because they are invalid XML characters and the data needs to be correct in XML. For example, these type of characters: ubuntu@instenv-226703-n3fe:/Attachments$ awk '{FS="&"} {print $2 $3}'…