Fast upload data to postgres

SELECT art, type INTO OUTFILE '/var/lib/mysql-files/exported_data.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM art;

LOAD DATA INFILE '/var/lib/mysql-files/exported_data.csv' INTO TABLE product_to_types FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (product_id, type_id);

docker cp exported_data.csv postgres-container:/exported_data.csv

docker exec -it postgres-container psql -U postgres -d mydatabase

COPY product_to_types (product_id, type_id) FROM '/exported_data.csv' DELIMITER ',' CSV HEADER;