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