Re: csv copy error

2021-12-31 Thread ourdiaspora
On Thursday, December 30th, 2021 at 7:30 AM, Guillaume Lelarge wrote: > Hi, > > Le mer. 29 déc. 2021 à 22:08, ourdiaspora a > écrit : > > > > > \copy exampletable from '/local/path/to/examplefile.csv'; > > > > You should tell the CSV command you're using a CSV file. By default, COPY > think

Re: csv copy error

2021-12-29 Thread Guillaume Lelarge
Hi, Le mer. 29 déc. 2021 à 22:08, ourdiaspora 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: > > " > CREAT

Re: csv copy error

2021-12-29 Thread David G. Johnston
On Wednesday, December 29, 2021, Adrian Klaver wrote: > On 12/29/21 13:08, ourdiaspora wrote: > >> >> " >> \copy exampletable from '/local/path/to/examplefile.csv'; >> " >> > > \copy exampletable from '/local/path/to/examplefile.csv with csv'; > > Right idea though that won’t execute for three

Re: csv copy error

2021-12-29 Thread Adrian Klaver
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 sma

csv copy error

2021-12-29 Thread ourdiaspora
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) ); " "