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