1 year ago
#359525

Nillo
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"
Can anyone think of a way to solve this?
database
postgresql
data-transfer
dbeaver
0 Answers
Your Answer