Re: COPY command on windows???

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY command on windows???
Date: 2009-07-17 18:23:34
Message-ID: h3qfj4$slk$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas wrote on 17.07.2009 20:06:
> Hi,
> I'd like to read a csv file into PG 8.4.
>
> COPY relations FROM E'd:\\relations.csv' CSV HEADER;
>
> It throws (translated):
> ERROR: can't open file >>d:\relations.csv<< for reading
> file or directory not found

Try

COPY relations FROM 'd:/relations.csv' CSV HEADER;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-07-17 18:33:56 Re: initdb failure on Windows XP
Previous Message Sachin Srivastava 2009-07-17 18:12:59 initdb failure on Windows XP