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

From: David Noel <david(dot)i(dot)noel(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: COPY TO returns "ERROR: could not open file for writing: No such file or directory"
Date: 2014-05-24 06:21:43
Message-ID: CAHAXwYDhwxsb9iP9sA0r68R8dHb1iugT7c=wi82wCAqamXaLQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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';

gives me:

ERROR: could not open file
"/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy" for
writing: No such file or directory

Running it in pgadmin3 I get the additional output:

SQL state: 58P01

I've tried creating a file named
"pagedump.2014-03-01.to.2014-04-01.copy", changing its permissions,
and changing its owner to pgsql, all with no luck.

The syntax for COPY is:

COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }
TO { 'filename' | PROGRAM 'command' | STDOUT }
[ [ WITH ] ( option [, ...] ) ]

...so it *should* be running just fine. I can't figure out why it's not.

FreeBSD. PostgreSQL 9.3.

Has anyone run into this before?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2014-05-24 08:27:58 Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory"
Previous Message Chris Ernst 2014-05-23 21:12:47 Re: Downtime-free 'alter table set tablespace'