Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group