ERROR: COPY quote must be a single one-byte character

Question

COPY public.performance (fl_date, mkt_carrier, mkt_carrier_fl_num, origin, origin_city_name, origin_state_abr, dest, dest_city_name, dest_state_abr, dep_delay_new, arr_delay_new, cancelled, cancellation_code, diverted, carrier_delay, weather_delay, nas_delay, security_delay, late_aircraft_delay) 
FROM '/Users/akind/OneDrive/Desktop/SQL/querying-data-postgresql/OntimeCarrier.csv' 
DELIMITER ',' 
CSV HEADER ENCODING 'UTF8' 
QUOTE '\"' 
ESCAPE '''';

After running this command, I got the error: COPY quote must be a single one-byte character. I have tried checking solutions on the web but none of them suit my needs.

You don't need to escape the double-quote character. It's just `QUOTE '"'`. — AdamKG, Nov 07 '20 at 11:09
@AdamKG make it the answer so its quicker to find for others maybe, thanks anyways — Matthew Barnden, Jan 29 '21 at 12:43

score 2 · Answer 1 · edited Apr 14 '22 at 07:29

2

COPY public.performance (fl_date, mkt_carrier, mkt_carrier_fl_num, origin, origin_city_name, origin_state_abr, dest, dest_city_name, dest_state_abr, dep_delay_new, arr_delay_new, cancelled, cancellation_code, diverted, carrier_delay, weather_delay, nas_delay, security_delay, late_aircraft_delay) 
FROM '/Users/Public/Documents/postgres_coding/code/OntimeCarrier.csv'
DELIMITER ',' 
CSV HEADER ENCODING 'UTF8' 
QUOTE '"' 
ESCAPE '''';

edited Apr 14 '22 at 07:29

Akber Iqbal

14,487
12
48
70

answered Apr 13 '22 at 21:58

Boitumelo

21
5

I am getting error - ``` SQL Error [58P01]: ERROR: could not open file "/Users/prats/Downloads/querying-data-postgresql/OntimeCarrier.csv" for reading: No such file or directory Hint: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy. ``` – PAA Sep 18 '22 at 07:07

ERROR: COPY quote must be a single one-byte character

1 Answers1