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(dot)klaver(at)aklaver(dot)com