postgres provider: improve value quoting

qgis · Mar 6, 2014 · 7829e7a · 7829e7a
1 parent d991ebf
commit 7829e7a
Showing 1 changed file with 4 additions and 2 deletions.
diff --git a/src/providers/postgres/qgspostgresconn.cpp b/src/providers/postgres/qgspostgresconn.cpp
@@ -772,8 +772,10 @@ QString QgsPostgresConn::quotedValue( QVariant value )
     case QVariant::String:
       QString v = value.toString();
       v.replace( "'", "''" );
-      v.replace( "\\\"", "\\\\\"" );
-      return v.prepend( "'" ).append( "'" );
+      if( v.contains( "\\" ) )
+        return v.replace( "\\", "\\\\" ).prepend("E'").append("'");
+      else
+        return v.prepend( "'" ).append( "'" );
   }
 }