"George Weaver" <gweaver(at)shaw(dot)ca> writes:
> Actually, I found that the double backslashes are required whether the E is
> used or not:
You must be using a relatively old PG version then. Default behavior
since around 9.1 has been that backslashes aren't special except
in E'' strings.
regards, tom lane