Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory" - Mailing list pgsql-general

From David G Johnston
Subject Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory"
Date
Msg-id 1400944281666-5804858.post@n5.nabble.com
Whole thread Raw
In response to COPY TO returns "ERROR: could not open file for writing: No such file or directory"  (David Noel <david.i.noel@gmail.com>)
Responses Re: Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory"  (David Noel <david.i.noel@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Jack Douglas"
Date:
Subject: Data Checksum feature and streaming replication
Next
From: "Jack Douglas"
Date:
Subject: new index type with clustering in mind.