Horton

BUG #1350: Backslash ecape charcter violates ISO/ANSI spec and is hazardous

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

View thread
From: "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>
To: pgsql-bugs@postgresql.org
Date: 2004-12-17T02:39:52Z
Lists: pgsql-bugs 
The following bug has been logged online:

Bug reference:      1350
Logged by:          Ken Johanson

Email address:      ken@kensystem.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.