Kelly
Reputation: 1
ERROR: could not open file "C:\Users\kelly\Downloads\orders_data.csv" for reading: No such file or directory
It shows this when I try to import a csv file to my postgresql
I did this but still shows similar error
COPY public."orders_data" from 'C:\Users\kelly\Downloads\orders_data.csv' DELIMITERS ',' csv Header;
I have created my table already, I just want to import the csv files into the table but I keep getting error message
Upvotes: 0
Views: 266
Answers (0)
Related Questions
- I am trying to copy a file, but getting error message
- Constant failure to import csv file via copy command in postgrsql
- ERROR: could not stat file "XX.csv": Unknown error
- Postgres SQL - error: must be superuser to copy to or from a file
- Postgres COPY FROM csv file- No such file or directory
- PostgreSQL: Could not open file for reading. Permission denied. SQL state: 42501
- psql /copy “No such file or directory”
- PostgreSQL COPY command with csv file
- \copy permission denied while importing CSV to Postgres on Ubuntu
- Postgresql cannot find file name specified in copy command