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'
...
ibo3
Last Activity: Dec 25 '07, 06:27 AM
Joined: Sep 18 '07
Location:
-
Converting an Access database to Postgresql
Does anyone know of a free not trial tool, for converting an access database to Postgresql? I used a trial tool that only converted 5 rows I need one that can do it all. -
I was doing it from the sql prompt. Know I have don it from the command prompt and I get a different error.
C:\Documents and Settings\Ibo>my sqlimport -c employeeID,quar ter,initials,Q1 ,Q2,Q
3,Q4,Q5,Q6,Q7,Q 8,Q9,Q10,Q11,Q1 2,Q13,Q14,Q15,Q 16,Q17,Q18,Q19, Q20,Q21,Q22 --delete --fields-terminated-by=: -u root MyNorthwind "C:\Documen ts and Settings\Ibo\De sktop\evaluatio ns.txt"
'mysqlimport' is not recognized... -
importing a data file - mysqlimport
I am having trouble trying to import a txt file. Can someone tell me what these errors are?
-> mysqlimport --delete -c employeeID quarter initials Q1 Q2 Q3 Q4 Q5 Q6 Q7
Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 --fields-enclosed-by=':' -u root evaluations C:\Documents and Settings\Ibo\De sktop\La1 784\cResp_imp.t xt
ERROR:
Unknown command '\D'.
ERROR:
Unknown command '\I'.... -
thank you for your help!!!
I will check into the String.split method...Leave a comment:
-
No, I get one long stringLeave a comment:
-
Then how would I pull out each value from the arraylist?...Leave a comment:
-
Fixing Scnanner scan.hasNext();, infinite loop Java
/** I have to use the scanner class (no alternatives), to record a dynamic amount of grades. I use the hasNext() method to get the next value on the same line. For some reason when I am done entering numbers and I press enter the curser waites on the next line and does not exit the program. I want to be able to exit the program once I have entered multable grades and then pressed enter. */
public void enterGrades()...
No activity results to display
Leave a comment: