COPY question - Mailing list pgsql-general

From Szymon Guz
Subject COPY question
Date
Msg-id AANLkTi=JkFKFp=_2rrgXh-Rw1J55hBTptvx7qjwJUj6M@mail.gmail.com
Whole thread Raw
Responses Re: COPY question
Re: COPY question
List pgsql-general
Hi,
I still get the same error while using COPY FROM 'file'. I have to pass the full directory for this to work, example:

COPY first (a,b,c) FROM '1st_file.csv' with csv header delimiter ',';
ERROR:  could not open file "1st_file.csv" for reading: No such file or directory

The same when I use: '.1st_file.csv' or './1st_file.csv'.

No errors when I give the full path.

Giving the full path is stupid, how can I use just the file name?

[PostgreSQL 9.1alpha1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit]


regards
Szymon



pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Advice needed on application/database authentication/authorization/auditing model
Next
From: Raymond O'Donnell
Date:
Subject: Re: COPY question