PostgresSQL: public schema export does not escape single quotes

[nicofrand]

Describe the bug

The exported SQL file is unusable because the single quotes are not escaped.

INSERT INTO "public"."TestingTable" ("configuration") VALUES ('BUG à l\'apostrophe');# INSERT INTO `TestingTable` (`configuration`) VALUES ("Bug à l'apostrophe");

To Reproduce

1. Create a table "TestingTable" in a postgresql database
2. Add a "configuration" field with type "text"
3. Insert a row with the following content: Bug à l'apostrophe such as below
4. Export the public schema as a single SQL file

Expected behavior

The single quotes are properly escaped.

Screenshots

Application (please complete the following information):

• App client: Antares - SQL client
• App version: 0.7.34
• Installation source: https://antares-sql.github.io/antares-ppa ./ Packages

Environment (please complete the following information):

• OS name: Kubuntu
• OS version: 25.04
• DB name: Postgresql
• DB version: 17

[vl-ivanov]

Same issue here, flatpak version on Fedora.