ERROR: invalid input syntax for integer

From: Jonatan Reiners <jreiners(at)encc(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: ERROR: invalid input syntax for integer
Date: 2012-05-30 13:21:42
Message-ID: CAEiji7OFkHB5mt=vSi612R8fNePCqRvjypcV7eSYSv0UaMwJZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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:
3192 95956 48901 1018 NULL Мурзилка 3 2006-

\copy abos from '/Users/jreiners/Downloads/text.txt' (encoding 'utf-8',
null 'NULL');
ERROR: invalid input syntax for integer: "3192"

I couldn't find any clues. Please help me.

Kind regards,
Jonatan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2012-05-30 18:18:04 Re: ERROR: invalid input syntax for integer
Previous Message Ilija Vidoevski 2012-05-28 17:21:37 Re: return values(table) from stored function from MS visual foxpro