Postgres Pro
Downloads
Home   >   mailing lists

COPY FROM file error: could not open file ... for reading: No such file or directory - Mailing list pgsql-novice

From Ryszard Czermiński
Subject COPY FROM file error: could not open file ... for reading: No such file or directory
Date
Msg-id CANS_SThtR_sqPUj-FXqND89=m3sLy1PXZe17-4no_DRg6RWvQA@mail.gmail.com
Whole thread Raw
Responses Re: COPY FROM file error: could not open file ... for reading: No such file or directory
List pgsql-novice
Tree view
I am trying to import data from csv file to a table, but COPY command
fails with "No such file or directory" error message - despite the fact that the file I am trying to read is definitely there. See below.

Apparently (as a novice :) I am missing something - your help will be highly appreciated.

Best regards,
Ryszard

$ more import_from_csv.sql
CREATE TABLE addr
(STREET varchar, CITY varchar, STATE char(2), ZIP char(10));
COPY addr FROM 'addr.csv' DELIMITER ',' CSV;
$ psql -U postgres -c 'drop table addr'
DROP TABLE
$ wc -l addr.csv
2 addr.csv
$ psql -U postgres -f import_from_csv.sql
CREATE TABLE
psql:import_from_csv.sql:3: ERROR:  could not open file "addr.csv" for reading: No such file or directory
$ psql --version
psql (PostgreSQL) 9.3.4
$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=14.04
DISTRIB_CODENAME=trusty
DISTRIB_DESCRIPTION="Ubuntu 14.04 LTS"
$ 


pgsql-novice by date:

Previous
From: "lmanorders"
Date:
Subject: Re: INSERT INTO FROM SELECT
Next
From: Szymon Guz
Date:
Subject: Re: COPY FROM file error: could not open file ... for reading: No such file or directory