Re: inserting/updating a field with the contents of a text file - Mailing list pgsql-novice

--- Phillip Smith <phillip.smith@weatherbeeta.com.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.