On 12/29/21 13:08, ourdiaspora wrote:
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';
"
\copy exampletable from '/local/path/to/examplefile.csv with csv';
CSV file contents:
"
1,m
2,m
9,t
"
--
Adrian Klaver
adrian.kla...@aklaver.com
