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