COPY command error in psql.

My guess is you've only changed those permissions on the directory &
file in question - not all the directories leading up to it:

 chmod a+r /home/ms/db/csv/AB.csv
 chmod a+x /home/ms/db/csv /home/ms/db /home/ms

Also, since this not really a PostgreSQL problem, you can test this
without PostgreSQL in the loop:

 su - postgres
 ls -l /home/ms/db/csv/AB.csv

Lee.

Matthew Stanfield writes:
 > I'm trying to import tables in psql but am getting a permission denied
 > error. I'm using the '\i file' command as I intend to import 100+ tables
 > and want to set this up to run overnight (almost 1 GB of data is going in).
 >
 > My test for this is not working. I have a 'batch' file the contents of
 > which are (at the moment) only:
 >
 > COPY ab FROM '/home/ms/db/csv/AB.csv'
 >
 > Table 'ab' exists as does the csv file and I am logged in as 'postgres'.
 >
 > I am getting this error when I run "\i batchfile":
 >
 > psql:batchfile:1: Error: Copy command, running in backend with effective
 > uid 26, could not open file '/home/ms/db/csv/AB.csv' for reading. Errorno =
 > permission denied (13).