Re: Problems with Quotes

On Jan 12, 2005, at 1:08 PM, Kieran Ashley wrote:

> I've tried using the replace() function to get rid of the ", but I
> can't figure out how to use it without throwing an error. I tried
>
> replace(col_name, '\"', '')
>
> and several other permutations but to no avail, do I need to use
> something like an ASCII character code in order to get rid of a quote?
> If so which one, and if not, is there a better solution?
>

Try '"' as in

select replace('this "is" it', '"', '');
replace
------------
this is it
(1 row)

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL