'Errors in Data-Transfer due to quotes in column-fields
I am trying to do a standard data-transfer from a bunch of tables (from CSV, DB2 and PostGreSQL) into a PostGreSQL-instance. The tool I am using is Dbeaver Light's Data Transfer Task.
However, I am facing a ton of errors and I have tracked it down to being due to the actual content of the data.
What I see in the data are examples like this:
Resulting in the following error:
I believe the errors arise due to the " in the data since these are used to qualify colums like so:
SELECT "Column1", "Column2" FROM "schema"."table"
The setting I am using are:
Can anyone think of a way to solve this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|