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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to