PostgreSQL: How to add data?

Question

PostgreSQL

I have columns: col1 text, col2 text, col3 double precision, col4 double precision, col5 numeric. Need to write data: text, "text2", "439, 86 [404]", "0.39", "0.11", "37.70%".
The code:

test=# COPY dataToImport2 FROM '/opt/DataToImport2.csv' WITH (FORMAT csv);

Mistake:

ERROR:  invalid input syntax for type double precision: "0,39"
CONTEXT:  COPY datatoimport2, line 1, column summaprodazhtyisrub: "0,39"

I understand that the error is related to the characters "," and "%". If you replace them, then there is no error. Can I write a request so that the replacement occurs automatically?

Answer 1

First, copy to another table with text fields (temporary table is quite a suitable place), then insert .. select with a request to transfer where necessary with any manipulations along the way.
Or make a storage in any language and read the file through it, converting the data along the way.