Hi,
Le mer. 29 déc. 2021 à 22:08, ourdiaspora <ourdiaspora@xxxxxxxxxxxxxx> a écrit :
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
"
You should tell the CSV command you're using a CSV file. By default, COPY thinks it's a TSV file.
--
Guillaume.
