From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: quotes etc |
Date: | 2011-02-23 19:11:54 |
Message-ID: | 4D655BFA.5010900@encs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 02/22/2011 04:18 PM, Adrian Klaver wrote:
> On Tuesday, February 22, 2011 12:26:41 pm John Fabiani wrote:
>
> > Hi,
>
> > I would have thought that there would be a simple built-in function that
>
> > would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not
>
> > see anything?
>
> >
>
> > I am I wrong?
>
> >
>
> > Johnf
>
> Dollar quoting ? :
>
> http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html
>
> 4.1.2.4. Dollar-Quoted String Constants
>
> test(5432)aklaver=>SELECT $$D' Andes$$;
>
> ?column?
>
> ----------
>
> D' Andes
I like this $str$....$str$ very much!
Vote for this!
--
Lu Ying
From | Date | Subject | |
---|---|---|---|
Next Message | Ozer, Pam | 2011-02-23 23:41:06 | Function To Strip HTML |
Previous Message | Adrian Klaver | 2011-02-22 21:18:56 | Re: quotes etc |