The following bug has been logged online:
Bug reference: 1350
Logged by: Ken Johanson
Email address: ken(at)kensystem(dot)com
PostgreSQL version: 8.0 Beta
Operating system: Any
Description: Backslash ecape charcter violates ISO/ANSI spec and is
hazardous
Details:
I can't find any option to run the server in a more standard mode for string
escaping rules, of only needing to escape single quotes. The current
backslash-escape behavior is a huge problem for SQL statement portability, a
spec violation, and blindsides developers coming from Oracle, Sybase, MS,
etc.