On Fri, Sep 23, 2005 at 01:48:33PM +0200, Cédric Buschini wrote: > ===================== > psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF > /home/postgres/FILE > COPY TABLE TO stdout; > EOF > > psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF > COPY carax_exec_bck FROM '/home/postgres/FILE'; > EOF > ======================= > > I got this error : > ERROR: could not open file "/home/postgres/FILE" for reading: No such > file or directory Are the client and server on the same machine? The use of the -h option suggests perhaps not. In the first command you're redirecting psql's output to a file on the client machine, and in the second command you're trying to read a file on the server machine. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
