CODEWITHSUNDEEP
postgresql
Aaron Kreider
Aaron Kreider

Reputation: 1819

pg_dump: how to set standard_conforming_strings=off

I am doing a SQL dump with postgreSQL 9.1.23.

I want to set standard_conforming_strings=off

My goal is to import it into an earlier version (8.1).

I have tried setting the option in pgAdmin, but it changes it back when it does a dump.

How can I do this?

Upvotes: 1

Views: 3279

Answers (1)

Aaron Kreider
Aaron Kreider

Reputation: 1819

You can set it in postgres.conf.

standard_conforming_strings=off

Upvotes: 2

Related Questions