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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Kupershmidt | 2012-05-31 19:09:04 | Re: permissions |
Previous Message | Tom Lane | 2012-05-31 06:28:51 | Re: how to call stored procedures that are writes |