PostgreSQL driver relies on backslash escaping, inserting backslashes where necessary. Starting with version 9.1, PostgreSQL does NOT threat backslashes as escape characters by default (as mentioned here in a red box), so backslashes are doubled on insertion, but are kept on selection (as expected), so strings with backslashes fail to round-trip through the database.