On Tue, 13 Mar 2007 20:38:33 +0000 T E Schmitz <[EMAIL PROTECTED]> 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?
>From the "-h" option I assume that the server is not on the local machine and hence the file is not available to the server. You need to do something like this: psql -h lolek -U tes -d stockmarket -c "copy history from STDIN CSV" < /tmp/FTSE.csv -- D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
