1 year ago

#359525

test-img

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: enter image description here

Resulting in the following error: enter image description here

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: enter image description here enter image description here

Can anyone think of a way to solve this?

database

postgresql

data-transfer

dbeaver

0 Answers

Your Answer

Accepted video resources