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