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
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
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
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
