I'm trying to import csv file's table into pgAdmin using COPY command and getting the error:
ERROR: could not open file "R:\myfile.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.
The statement is:
copy tst_copy from 'R:\myfile.csv'