Re: the use of $$string$$

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