Re: the use of $$string$$

John Fabiani <johnf(at)jfcomputer(dot)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