COPY failure on directory I own

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY failure on directory I own
Date: 2011-08-30 17:14:06
Message-ID: alpine.LNX.2.00.1108301011080.13948@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to understand why this command fails:

nevada=# copy statdata to
'/home/rshepard/projects/nevada/queenstake/stats/chem.csv' with delimiter '|'
null as 'NA' CSV HEADER;
ERROR: could not open file
"/home/rshepard/projects/nevada/queenstake/stats/chem.csv" for writing:
Permission denied

The permissions on that directory are 755 and it's owned by me. Since I
have no problems writing other files to that directory I must have the
command syntax incorrect but I don't see where.

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-08-30 17:20:18 Re: COPY failure on directory I own
Previous Message Scott Ribe 2011-08-30 17:13:51 Re: IDLE queries taking up space