The following bug has been logged on the website: Bug reference: 7505 Logged by: Jeff Ovadya Email address: ovad...@gmail.com PostgreSQL version: 9.1.4 Operating system: PostgreSQL 9.1.4, compiled by Visual C++ build 150 Description:
INSERT INTO customer VALUES ( 20, 'Mr', 'Jeff', 'Baggott', 'Midtown Street A\\33', 'Milltown', 'MT9 8NQ', '746 3956'); results in two backslashes instead of a single one. Inserting the address with a single backslash succeeds in saving the backslash with the address. Also noticed similar issue escaping single quotes: Backslash will not work to escape, but doubling up the quotes works. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs