I am new to postgres, probably missing something silly like (the correct name of my directory). Can someone guide me?
I am following book instructions, Practical SQL by Anthony DeBarros
Code:
copy us_counties_2010 from 'C:UsersobellaOneDriveDesktopus_counties_2010.csv' with (FORMAT CSV, HEADER);
Error:
ERROR: could not open file "C:UsersobellaOneDriveDesktopus_counties_2010.csv" for reading: Permission denied HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's copy. SQL state: 42501
copy us_counties_2010 from 'C:UsersobellaOneDriveDesktopus_counties_2010.csv' with (FORMAT CSV, HEADER);
Expected:
Query returned successfully: 3143 rows affected
Actual:
See Question&Answers more detail:osERROR: could not open file "C:UsersobellaOneDriveDesktopus_counties_2010.csv" for reading: Permission denied HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's copy. SQL state: 42501