Re: Unicode escape codes

Chris Campbell <ccampbell@cascadeds.com> writes:
> Update data1.systeminfo SET aicompanyfile='C:\Users\Public\Documents\Intuit\QuickBooks\Company
Files\acme_rockets.QBW'

> The issue is that Postgres interprets the back slashes in the path name as escapes and errors out with "invalid
unicodeescape"  Okay, I get it.  Back slashes are symbols for escape codes. 

> So my question is, what options do I have other than "swapping out"
the offending back-slash for some other character, then having to
remember to swap it back after I fetch the table from the database?
There must be a more elegant solution.

You can double the backslashes ('C:\\Users...') or you can turn on
standard_conforming_strings.  The latter is best done only with
considerable testing, though, because it's likely to break anything
that knows backslashes are special.

            regards, tom lane