Re: [GENERAL] COPY command on windows???

2009-07-17 Thread Thomas Kellerer 

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;


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] COPY command on windows???

2009-07-17 Thread Andreas 

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

The PG doc doesn't describe the path-syntax for windows.
With google I only find references to permission errors.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general