SET SEARCH_PATH TO public;
DROP TABLE IF EXISTS import_test;
CREATE TABLE import_test
(
  id BIGINT NOT NULL,
  textfield text,
  CONSTRAINT import_test_pkey PRIMARY KEY (id)
);
COPY import_test (id, textfield) FROM '/home/patrick/Desktop/csv_with_multiline_records.csv'  DELIMITER ';' CSV HEADER;  --change the location of csv_with_multiline_records.csv to yours
SELECT * FROM import_test;

