COPY command error

[ibo3]

I used the copy command as stateed below, to copy a file containing data, which I want to load into my evaluations table. I get the following error, can some one explain to me what I may be doing wrong.

COPY evaluations FROM 'c:\evaluations.txt'
DELIMITERS ':';


WARNING: nonstandard use of escape in a string literal
LINE 1: COPY evaluations FROM 'c:\evaluations.txt'
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.

ERROR: could not open file "c:evaluations.txt" for reading: No such file or directory
SQL state: 58P01

[rski]

I used the copy command as stateed below, to copy a file containing data, which I want to load into my evaluations table. I get the following error, can some one explain to me what I may be doing wrong.

COPY evaluations FROM 'c:\evaluations.txt'
DELIMITERS ':';


WARNING: nonstandard use of escape in a string literal
LINE 1: COPY evaluations FROM 'c:\evaluations.txt'
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.

ERROR: could not open file "c:evaluations.txt" for reading: No such file or directory
SQL state: 58P01

See here
http://www.postgresql.org/docs/8.2/i.../sql-copy.html
where the filename option is described