I'm migrating a legacy application's database from Postgres 8.1 to Postgres 9.3
In order to avoid compatibility issues, I'd like to keep the
standard_conforming_strings parameter to it's default value in 8.1:
So, I create the databases using following in the schema:
SET standard_conforming_strings = off;
But a pg_dump of the database reveals that Postgres has changed the value to
SET standard_conforming_strings = on;
How can I prevent this?