replacing single quotes

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: replacing single quotes
Date: 2007-10-10 04:07:58
Message-ID: 1191989278.18077.21.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Input is of form

'ppp','aaa','bbb'

I want it to be stripped of quotes to become

ppp,aaa,bbb

escaping the quote would work but it means I will have to do some magic
on the input as well to escape it prior to replacing it.

select replace('AB\'A','\'','C') this works

Can I buy a clue here?

oh.. I;ve also tried to use quote_literal but no go..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-10-10 04:50:09 Re: SLEEP in posgresql
Previous Message Guy Rouillier 2007-10-10 03:53:47 Re: SLEEP in posgresql