Delimiter
Load first, convert later. When a file has odd formats (semicolon delimiter, decimal commas, day-first dates) COPY it into text columns, then cast with INSERT ... SELECT.
task
Load orders_semicolon.csv (; delimiter, decimal comma, DD/MM/YYYY) into st as text, then insert typed rows into ord2.