Readers,
Please could anyone help with the following error produced:
"
ERROR: invalid input syntax for integer: "1,m "
CONTEXT: COPY exampletable, line 1, column examplenumber: "1,m "
The database commands:
"
CREATE TABLE exampletable (examplenumber smallint,
exampletitle varchar(500)
);
"
"
\copy exampletable from '/local/path/to/examplefile.csv';
"
CSV file contents:
"
1,m
2,m
9,t
"