- Joined
- 8 Apr 2003
- Messages
- 6,376
i have a txt file with a few companies names in and rather than put them in one by one (there are about 100+) i have been trying to use the compy command
COPY comanies FROM /usr/home/carpo/comp.txt
but it always comes back with a syntax error
ERROR: invalid input syntax for integer: "ABC Computers,"
CONTEXT: COPY comps, line 1, column comps_id: "ABC Computers,"
i have tried with a cvs file but some error remains
COPY comanies FROM /usr/home/carpo/comp.txt
but it always comes back with a syntax error
ERROR: invalid input syntax for integer: "ABC Computers,"
CONTEXT: COPY comps, line 1, column comps_id: "ABC Computers,"
i have tried with a cvs file but some error remains