| 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: | Whole Thread | Raw Message | 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
| 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 |