Why you don't make: COPY carax_exec_bck TO '/home/postgres/FILE'; ? Then you could also use something like.... COPY carax_exec_bck TO '/home/postgres/FILE' WITH BINARY; etc. Cédric Buschini wrote: > Hi > > Here I am again with my 'stupd' question > > here is a script : > > ===================== > 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 > > ???? > > thx > > cedric > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
