The following bug has been logged on the website:
Bug reference: 7505
Logged by: Jeff Ovadya
Email address: ovadyaj@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.