By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

COPY command error

P: 8
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
Dec 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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
Jan 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.