Enc: Help to replace caracter - Mailing list pgsql-general

I Need to replace string (" ) in the situation below :

 

select  clie_nmcliente    from cadastro.cliente where clie_nmcliente like '%"%';

 

result:

JOANA D"ARCALMEIDA"
EMLURB "P M R."
CECILIA D"CAGNO"
HELENA FERREIRA D"FREITAS"
JOSE M. "BARRACA DO BOLA"
FORTE" DUNAS BAR"
JOANA D"ARC R. DE SOUZA
ASSEMBLEIA DE DEUS"
USINA SALGADO"SUPRIMENTO
JOSE MOURA  'BIGODE"
BEATRIZ MEDEIROS D"EMERY

Any help me to create pgPL/sql or funcion  to replace ( " )  to null value, I have many table with this.

Thanks for help