Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid input syntax for integer

From: Jonatan Reiners <jreiners(at)encc(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: invalid input syntax for integer
Date: 2012-05-31 14:03:59
Message-ID: CAEiji7Posrm2yUGNEhXwmR=xyR0j1HMiiPDo63SoBCVQ0OTLig@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
you were right. It was the BOM.
Thanks a lot.

On Wed, May 30, 2012 at 8:18 PM, Steve Crawford <
scrawford(at)pinpointresearch(dot)com> wrote:

> On 05/30/2012 06:21 AM, Jonatan Reiners wrote:
>
>> Hello Folks,
>> we had this topic before on this list.
>>
>> This is is a new error with the same message.
>>
>> I tried to copy from a text file and a csv file with the same issue.
>>
>> the integer values are not quoted in the file
>>
>> source:
>> 3192;95956;48901;1018;NULL;**Мурзилка;3;2006-
>>
>> \copy abos from '/Users/jreiners/Downloads/**test.csv' (format csv,
>> delimiter ';', encoding 'utf-8');
>> ERROR:  invalid input syntax for integer: "3192"
>>
>>
>> Source:
>> 319295956489011018NULLМурзилка**32006-
>>
>> \copy abos from '/Users/jreiners/Downloads/**text.txt' (encoding
>> 'utf-8', null 'NULL');
>> ERROR:  invalid input syntax for integer: "3192"
>>
>>  Is this the first line in the file? Have you verified the file and made
> absolutely sure there are no invisible characters. Use something like xxd
> to examine the file before checking anything else. I'm not sure how
> PostgreSQL will work if there is a byte-order-mark at the beginning of a
> file and don't have time to test that at the moment.
>

In response to

pgsql-novice by date

Next:From: Josh KupershmidtDate: 2012-05-31 19:09:04
Subject: Re: permissions
Previous:From: Tom LaneDate: 2012-05-31 06:28:51
Subject: Re: how to call stored procedures that are writes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group