Jure Kodzoman wrote:
On Tue, 2007-03-13 at 20:38 +0000, T E Schmitz wrote:
I am trying to batch-load a tab-separated CSV file:
psql -h lolek -U tes -d stockmarket -c "copy history from
'/tmp/FTSE.csv' CSV";
ERROR: could not open file "/tmp/FTSE.csv" for reading: No such file or
directory
The file exists. Do I need to escape the quotes?
Try setting the permissions chmod a+r /tmp/FTSE.csv
The problem was indeed that COPY was expecting the file on the server.
--
Regards,
Tarlika Elisabeth Schmitz
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
