On Fri, Nov 4, 2011 at 7:38 AM, John Fabiani <jo...@jfcomputer.com> wrote: > Hi, > 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.
E'...' is the escape string syntax. You can find examples of it in this page (among others) http://www.postgresql.org/docs/9.0/interactive/functions-matching.html You might want to read up on standard_conforming_strings and escape_string_warning too, as they influence how the escaping works. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql