<p>I created patch for postgres module and will test soon.</p>
<pre><code>diff --git a/src/modules/db_postgres/km_pg_con.c b/src/modules/db_postgres/km_pg_con.c
index 5a7225c..b66a94a 100644
--- a/src/modules/db_postgres/km_pg_con.c
+++ b/src/modules/db_postgres/km_pg_con.c
@@ -52,6 +52,7 @@ struct pg_con *db_postgres_new_connection(struct db_id *id)
        int i = 0;
        const char *keywords[10], *values[10];
        char to[16];
+       PGresult   *res;
 
        LM_DBG("db_id = %p\n", id);
 
@@ -141,6 +142,15 @@ struct pg_con *db_postgres_new_connection(struct db_id *id)
        }
 #endif
 
+       res = PQexec(ptr->con, "SET bytea_output=escape");
+       if (PQresultStatus(res) != PGRES_COMMAND_OK)
+       {
+               LM_ERR("cannot set blob output escaping format\n");
+               PQclear(res);
+               goto err;
+       }
+       PQclear(res);
+
        return ptr;
 
 err:
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/1255#issuecomment-427719271">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZWxxLH0KenSf4cF9zbSuVdrigPABks5uitQwgaJpZM4PoBLO">mute the thread</a>.<img src="https://github.com/notifications/beacon/AF36ZWKdIjO8Vt4LSBavBLUsZopq3XRSks5uitQwgaJpZM4PoBLO.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://assets-cdn.github.com/images/email/message_cards/header.png","avatar_image_url":"https://assets-cdn.github.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"PERSON","message":"@sergey-safarov in #1255: I created patch for postgres module and will test soon.\r\n```\r\ndiff --git a/src/modules/db_postgres/km_pg_con.c b/src/modules/db_postgres/km_pg_con.c\r\nindex 5a7225c..b66a94a 100644\r\n--- a/src/modules/db_postgres/km_pg_con.c\r\n+++ b/src/modules/db_postgres/km_pg_con.c\r\n@@ -52,6 +52,7 @@ struct pg_con *db_postgres_new_connection(struct db_id *id)\r\n \tint i = 0;\r\n \tconst char *keywords[10], *values[10];\r\n \tchar to[16];\r\n+\tPGresult   *res;\r\n \r\n \tLM_DBG(\"db_id = %p\\n\", id);\r\n \r\n@@ -141,6 +142,15 @@ struct pg_con *db_postgres_new_connection(struct db_id *id)\r\n \t}\r\n #endif\r\n \r\n+\tres = PQexec(ptr-\u003econ, \"SET bytea_output=escape\");\r\n+\tif (PQresultStatus(res) != PGRES_COMMAND_OK)\r\n+\t{\r\n+\t\tLM_ERR(\"cannot set blob output escaping format\\n\");\r\n+\t\tPQclear(res);\r\n+\t\tgoto err;\r\n+\t}\r\n+\tPQclear(res);\r\n+\r\n \treturn ptr;\r\n \r\n err:\r\n```"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/1255#issuecomment-427719271"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/1255#issuecomment-427719271",
"url": "https://github.com/kamailio/kamailio/issues/1255#issuecomment-427719271",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
},
{
"@type": "MessageCard",
"@context": "http://schema.org/extensions",
"hideOriginalBody": "false",
"originator": "AF6C5A86-E920-430C-9C59-A73278B5EFEB",
"title": "Re: [kamailio/kamailio] DB Postgres BLOB conversion for presence (#1255)",
"sections": [
{
"text": "",
"activityTitle": "**sergey-safarov**",
"activityImage": "https://assets-cdn.github.com/images/email/message_cards/avatar.png",
"activitySubtitle": "@sergey-safarov",
"facts": [

]
}
],
"potentialAction": [
{
"name": "Add a comment",
"@type": "ActionCard",
"inputs": [
{
"isMultiLine": true,
"@type": "TextInput",
"id": "IssueComment",
"isRequired": false
}
],
"actions": [
{
"name": "Comment",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueComment\",\n\"repositoryFullName\": \"kamailio/kamailio\",\n\"issueId\": 1255,\n\"IssueComment\": \"{{IssueComment.value}}\"\n}"
}
]
},
{
"targets": [
{
"os": "default",
"uri": "https://github.com/kamailio/kamailio/issues/1255#issuecomment-427719271"
}
],
"@type": "OpenUri",
"name": "View on GitHub"
},
{
"name": "Unsubscribe",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"MuteNotification\",\n\"threadId\": 262148814\n}"
}
],
"themeColor": "26292E"
}
]</script>