How can I replace the 'S for a 's in postgresql?

Question

I have a table with large amount of 'S wrongly added and I want to replace it for 's:

I have tried with replace(field, ''S', ''s') but obviously doesn't accept it for the ', I also tried with the $$'$$ but still doesn't work.

The current version of PostgreSQL is 11 I have look into different threads and tried the solution there but didn't recognize i.e.

try this : `replace(field, E'\'S', E'\'s')` – Edouard Jan 13 '22 at 17:33 — Edouard, Jan 13 '22 at 17:33

score 3 · Accepted Answer · answered Jan 13 '22 at 17:33

3

The quote is the escape character for quotes as well. So you need one more quote for each string: replace(field, '''S', '''s')

answered Jan 13 '22 at 17:33

clemens

1 Answers1