David Noel wrote > COPY (SELECT * FROM page WHERE "PublishDate" between '2014-03-01' and > '2014-04-01') TO > '/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy'; Is /home/ygg a client or server path? COPY != \copy David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/COPY-TO-returns-ERROR-could-not-open-file-for-writing-No-such-file-or-directory-tp5804853p5804858.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
