Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory"

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory"
Date: 2014-05-24 15:11:21
Message-ID: 1400944281666-5804858.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jack Douglas 2014-05-24 16:58:37 new index type with clustering in mind.
Previous Message Jack Douglas 2014-05-24 11:54:28 Data Checksum feature and streaming replication