Dockerized PostgreSQL image: where to access CSV file to give as input?

Question

I have a dockerized Postgres container that I can manipulate from the shell using psql. I would like to fill the cities table from a CSV file:

\copy cities(location, latitude, longitude) FROM 'postgis.csv' DELIMITERS ',' CSV HEADER;

However, this command returns "postgis.csv: No such file or directory". How can I do the above in Docker and PostgreSQL? I've tried editing my docker compose file by adding

volumes:
  - ./src/db/pgdata:/var/lib/postgresql/data

And now I have the database data folder locally, but not sure where I should put the CSV file. Sorry for the noob question.

does your local ./src/db/pgdata folder contains this csv file? if so, what about copy cities(location, latitude, longitude) FROM '/var/lib/postgresql/data/postgis.csv' DELIMITERS ',' CSV HEADER; — ItayB
– ItayB, Commented Dec 26, 2020 at 13:55
How is the question programming-related? The question might be better suited for SuperUser or ServerFault. — Turing85
– Turing85, Commented Dec 26, 2020 at 13:57
Thanks a lot @ItayB! That worked. Maybe I can flag so that a mod can move this to the appropriate site. Apologies for this. — Cesare
– Cesare, Commented Dec 26, 2020 at 14:13

ItayB · Accepted Answer · 2020-12-26 16:16:32Z

1

does your local ./src/db/pgdata folder contains this csv file?

if so, what about

copy cities(location, latitude, longitude) FROM '/var/lib/postgresql/data/postgis.csv' DELIMITERS ',' CSV HEADER;

answered Dec 26, 2020 at 16:16

ItayB

11.6k11 gold badges61 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dockerized PostgreSQL image: where to access CSV file to give as input?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related