Re: the use of $$string$$ - Mailing list pgsql-sql

From Tom Lane
Subject Re: the use of $$string$$
Date
Msg-id 7743.1320418644@sss.pgh.pa.us
Whole thread Raw
In response to the use of $$string$$  (John Fabiani <johnf@jfcomputer.com>)
List pgsql-sql
John Fabiani <johnf@jfcomputer.com> writes:
> I just discovered that I can use $$string$$ to account for the problem of 
> single quotes in the string (or other strange char's).  However, I noticed 
> that the table field contained E'string'.  I actually tried to find info on 
> this but I did not find anything.  

> Could someone explain what it means or better provide a web link for me to 
> discover the info.

http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html

See "4.1.2.4. Dollar-quoted String Constants", about halfway down the
page.  You might care to read the rest of 4.1.2 while at it.
        regards, tom lane


pgsql-sql by date:

Previous
From: bricklen
Date:
Subject: Re: the use of $$string$$
Next
From: John Fabiani
Date:
Subject: Re: the use of $$string$$