When I perform a dump with pg_dump tool, with a "flat" sql format, pg_dump create a regular sql file but the restoration with pg_restore fails because the strings are not escaped. For example, single quotes used in strings are saved as single quotes, avoiding the correct parsing of the string and the entire file.

Is there a way to dump with character encoding and restore coorectly after ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.