From: | Johan Nel <johan(dot)nel(at)xsinet(dot)co(dot)za> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Small annoyance with COPY FROM |
Date: | 2012-09-28 12:56:14 |
Message-ID: | 923633d2-9542-4ff1-97b2-e6daacec1fa3@googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John | 2012-09-28 14:07:29 | problem logging on with new everyday user |
Previous Message | James David Smith | 2012-09-28 08:59:47 | Small annoyance with COPY FROM |