--- Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> wrote:
> Backslash ('\') will also cause problems. Replace them with double-backslash
> ('\\')
You can turn alter postgresql behavior towards backslash using standard_conforming_strings.
SET standard_conforming_strings = on;
http://www.postgresql.org/docs/8.2/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION
This way backslashes are treated as any other character.
when you are done:
SET standard_conforming_strings = off;
Regards,
Richard Broersma Jr.