Monday, January 3, 2011

Postgres - nonstandard use of \\ in a string error

If you see

WARNING: nonstandard use of \\ in a string literal
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.

Changing all '\\' to E'\\' is a good solution.

However, it will be very tedious if you have a bunch of data. Worst case is when this happen to \n in Linux machine.

A faster fix will be as follow

1. Open postgresql.conf
2. Find #standard_conforming_strings=off. By default, it is commented out by # and set to off
3. Change it to standard_conforming_strings=on
4. Restart postgres

This will cause postgres to treat backslashes as normal character.

If you want postgres to treat backslashes as escape character after turning stardard_conforming_string to on, you must put an E in front. IE, E'this is \\n a string'

No comments:

Post a Comment

Oracle - ORACLE error 959 encountered when importing with imp

If the dump is exported with imp, you cannot use impdp and you may face issue such as IMP-00003: ORACLE error 959 encountered ORA-009...