Re: Small annoyance with COPY FROM

James,

On Friday, 28 September 2012 11:00:18 UTC+2, James David Smith wrote:
> Not really a big issue, but just something which catches me out
> sometimes and I'm not sure if it's just me. When I want to import data
> from a CSV file I write the below:
> COPY temp_import_table
> FROM 'X:/aerasense_12-7-2012.csv' DELIMITERS ',' CSV HEAD
>
> But get the error:
> ERROR: could not open file "X:/aerasense_12-7-2012.csv" for reading:
> No such file or directory
>
> However when I move the file to within the PostgreSQL directory of my
> C: drive it works fine:
> Am I doing something wrong, or can PostgreSQL only import data from
> it's own directory?

I think it is a permission issue. Make sure the user (postgres) have at least read permissions to the folder.

Regards,

Johan Nel