From: | Dara Unglaube <dara(at)glifwc(dot)org> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Data stored as scientific notation, unable to convert to numeric |
Date: | 2018-06-29 12:41:00 |
Message-ID: | CA+ca-rqBuCTtuzYRnUMPC6NXGgi8GEiPLg6xDgLxd5_=KFOg0Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Greetings.
I am having a problem with scientific notation in a field. I have multiple
variables that are in a spreadsheet and loaded via CSV into postgres. The
results have a variety of significant digits which I would like to retain
(from integer to 0.000001). I import into a double precision field and
anything with 5 or more places right of the decimal gets automatically
converted to scientific notation (even if in the CSV it is imported as
0.000001). If I try to CAST these as numeric field or replace within the
double precision field, they revert back to scientific notation. Does
anyone have any idea on how to fix this?
Any help is greatly appreciated!
Dara
*--Dara J. Olson Unglaube*
Database Manager
Great Lakes Indian Fish & Wildlife Commission
(715) 682-6619 ext.2129
dara(at)glifwc(dot)org <dolson(at)glifwc(dot)org>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Froehlich | 2018-06-29 13:57:51 | RE: Data stored as scientific notation, unable to convert to numeric |
Previous Message | rohan.parkes | 2018-06-24 23:34:41 | Re: pg_restore hangs on materialized view [SEC=UNCLASSIFIED] |