Re: COPY command syntax error

On Wed, 2 Feb 2011, gabrielle wrote:

> That syntax (COPY table FROM '/path/to/file' WITH DELIMITER AS ':'
> CSV;) works for me in a similar test.

Gabrielle,

Worked for me, too, a couple of days ago when I first created the database
and table.

> Are you sure the file exists? Try taking off the "with ... csv" piece
> and see if you get the same error.

Yes it exists:

[rshepard(at)salmo
~/projects/nevada/queenstake/permitwatch/water-quality-info/csv_versions]$
ll import.csv
-rw-r--r-- 1 rshepard users 227399 2011-02-02 10:45 import.csv

And the psql result:

jerrittwq=# copy monitor from
'/home/rshepard/projects/queenstake/permitwatch/water-quality-info/csv_versions/import.csv';
ERROR: could not open file
"/home/rshepard/projects/queenstake/permitwatch/water-quality-info/csv_versions/import.csv"
for reading: No such file or directory

Thanks,

Rich