COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy

Question

I used reference: Connecting to Postgresql in a docker container from outside and still facing below issues -

@Prateeks-MacBook-Pro ~ % docker exec -it 7aa303a09ae5ec86dae4b9434a9d4b9d50ae5e3d1ce6d73ec7efde08c88675f6 /bin/sh
# su postgres
postgres@7aa303a09ae5:/$ psql
psql (14.4 (Debian 14.4-1.pgdg110+1))
Type "help" for help.

postgres=# 

postgres=# 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/prats/Documents/Postgres_data/OntimeCarrier.csv'
DELIMITER ',' 
CSV HEADER ENCODING 'UTF8' 
QUOTE '"' 
ESCAPE '''';
ERROR:  could not open file "/Users/prats/Documents/Postgres_data/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.
postgres=#

What happened when you tried the suggestion in the hint? – Sep 18 '22 at 07:53 — , Sep 18 '22 at 07:53
https://www.postgresql.org/docs/current/sql-copy.html – Frank Heikens Sep 18 '22 at 08:26 — Frank Heikens, Sep 18 '22 at 08:26

COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy

0 Answers0