Re: ERROR: relative path not allowed for COPY to file

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Andrew Taylor <andydtaylor(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: relative path not allowed for COPY to file
Date: 2013-02-12 17:37:24
Message-ID: 1360690644.5585.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Taylor <andydtaylor(at)gmail(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Little, Douglas 2013-02-12 17:45:22 design question - repeated updates on temp or perm table.
Previous Message Adrian Klaver 2013-02-12 17:31:07 Re: ERROR: relative path not allowed for COPY to file