Hi,
I want to load a file containning a column of FLOATS, into a table of
INTEGERs.
I tried:
COPY "Field" ("myintegers") from './myfloats.txt';
but got an error message:
ERROR: invalid input syntax for integer: "15.0"
CONTEXT: COPY Field, line 1, column WatchFreq: "15.0"
How can I go around this problem? is there any way to force copy to do the
right casting?
Thanks in advance,
Elinor