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

Invalid input syntax for integer

From: Hans Edwin Winzeler <hewinzeler(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Invalid input syntax for integer
Date: 2011-08-18 15:07:58
Message-ID: CABq1rrK9ao24fuMUHRtvN7oyTpTq-tGtZyzoEqnOn3Onznoc_g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

I am new to PostgreSQL and have a data format issue that I can't resolve.

The input table from my .csv file (about 10 million records) that I am
importing into PostgreSQL from a different program gives numbers in a format
as follows, for example: 0-1788.000000 to indicate the value -1788.
PostgreSQL gives me the error "invalid input syntax for integer" when I try
to import the number (or invalid for numeric, real, double precision, etc.
when I try to import it in those other formats). When I specify varchar(20)
I get no problems and can import it, but then I can't use it numerically.
How do I either:


   - Import the value as NUMERIC or INTEGER or REAL or FLOAT or something
   that I can use as a value rather than text, OR
   - How do I convert the varchar(20) that I have already imported into a
   numeric value?

Thanks

Edwin Winzeler

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-08-18 15:32:05
Subject: Re: Invalid input syntax for integer
Previous:From: Don ParrisDate: 2011-08-17 23:31:52
Subject: Re: Stuck Up In My Category Tree

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