Small annoyance with COPY FROM
| От | James David Smith |
|---|---|
| Тема | Small annoyance with COPY FROM |
| Дата | |
| Msg-id | CAMu32ADFBQPtrVMn0bfEyGD+ebN39Wn+0NbppnkC-ch5bdJKnA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Small annoyance with COPY FROM
|
| Список | pgsql-novice |
Hi all, 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: COPY temp_import_table FROM 'C:/Program Files (x86)/PostgreSQL/9.0/data/aerasense_12-7-2012.csv' DELIMITERS ',' CSV HEADER; Am I doing something wrong, or can PostgreSQL only import data from it's own directory? Thanks James
В списке pgsql-novice по дате отправления: