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