Re: csv copy error

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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.klaver@xxxxxxxxxxx