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:
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.
pgsql-general by date
|Next:||From: Scott Ribe||Date: 2011-08-30 17:20:18|
|Subject: Re: COPY failure on directory I own|
|Previous:||From: Scott Ribe||Date: 2011-08-30 17:13:51|
|Subject: Re: IDLE queries taking up space|