copy import csv problem - Mailing list pgsql-novice

From Peter Lowman
Subject copy import csv problem
Date
Msg-id 3CB8BB6A.20500@bigpond.com
Whole thread Raw
Responses Re: copy import csv problem
List pgsql-novice
Have only just installed RH7.2 and pgsql

I'm trying to import an access csv file have already setup db with
necessary columns.

COPY wests from '/home/peter/wests.csv' using delimiters ';';

ERROR: COPY command, running in background with effective uid 26, could
not open file '/home/peter/wests.csv' for reading. Errno = Permission
denied (13).

I can view the file with editors etc.  I'v tried su postgres, same result.

How can can I get permission?

Peter



pgsql-novice by date:

Previous
From: Peter Lowman
Date:
Subject: copy import csv problem
Next
From: Andrew McMillan
Date:
Subject: Re: copy import csv problem