Re: [GENERAL] ERROR: relative path not allowed for COPY to file

2013-02-12 Thread Kevin Grittner
Andrew Taylor wrote: > postgres=# COPY post_e_n > postgres-# TO 'usr/local/psql/csv/post_e_n.csv' > postgres-# WITH DELIMITER ',' > postgres-# CSV HEADER; > ERROR:  relative path not allowed for COPY to file I think you need a slash at the front of that path. -Kevin -- Sent via pgsql-genera

Re: [GENERAL] ERROR: relative path not allowed for COPY to file

2013-02-12 Thread Adrian Klaver
On 02/12/2013 09:19 AM, Andrew Taylor wrote: Hi, I must be being thick - can anyone tell me what I'm doing wrong? postgres=# COPY post_e_n postgres-# TO 'usr/local/psql/csv/post_e_n.csv' postgres-# WITH DELIMITER ',' postgres-# CSV HEADER; ERROR: relative path not allowed for COPY to file COP