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

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 (view raw or flat)
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

pgsql-novice by date

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

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