Postgres replace characters in string

Question

I have column with text where I need to change characters! For example

So I need to replace � with character D. I try next but I get error:invalid regular expression: quantifier operand invalid

update  tableT pp set descript=(select regexp_replace(descript,'�', 'D') 
FROM 
  tableT kk where pp.id=kk.id) ;

President Camacho · Accepted Answer · 2015-02-24 13:26:29Z

20

update tableT pp
set descript = (select replace(descript, '�', 'D') from tableT where id = pp.id)

Why don't use replace?

answered Feb 24, 2015 at 13:26

President Camacho

1,9407 gold badges27 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jarlh · Accepted Answer · 2018-12-18 08:30:01Z

14

It's just a plain UPDATE:

update  tableT set descript= regexp_replace(descript,'�', 'D')

add where descript like '%�%' to minimize transaction.

Or, as President Camacho says, why not use replace instead of regexp_replace?

answered Feb 24, 2015 at 13:26

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

plus 1 on the added WHERE