When querying a table containing phone numbers, I needed to keep only numeric characters, so I used the following to remove non-numeric characters.

select info original, regexp_replace(info, '[^0-9]', '', 'g') modified
from phone_numbers p
limit 10;