Re: csv copy error

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@aklaver.com