Matthew Stanfield <matthew(at)propertyknowledge(dot)com> writes:
> COPY ab FROM '/home/ms/db/csv/AB.csv'
> 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).
> Now I understand why this happened the first time I ran the command as only
> user 'ms' had any kind of permission for AB.csv.
What about permissions on the containing directories? That path
requires search (x) permission on each directory traversed to reach the
file...
regards, tom lane