Re: COPY command on windows??? - Mailing list 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;