Postgres Pro
Downloads
Home   >   mailing lists

Re: MSAccess to postgres on Windows Currency type problem - Mailing list pgsql-odbc

From Richard Broersma
Subject Re: MSAccess to postgres on Windows Currency type problem
Date
Msg-id CABvLTWGC2Db-Y3dne579gZh0Dx8usxpPxjfkpJP+r9_30Hsqew@mail.gmail.com
Whole thread Raw
In response to MSAccess to postgres on Windows Currency type problem  (albert <skarbat@gmail.com>)
Responses Re: MSAccess to postgres on Windows Currency type problem  (albert <skarbat@gmail.com>)
List pgsql-odbc
Tree view 
On Sun, Sep 11, 2011 at 3:08 PM, albert <skarbat@gmail.com> wrote:
> I am exporting a MSAccess database to Postgres under windows using ODBC.
> "the input syntax is invalid for type double precision <40868,8227>" .
> I have tried to export that same table using mdbtools' mdb-schema program
> and it works correctly, translating it to postgres "money" data type.

the postgresql data type you want is NUMERIC.
http://www.postgresql.org/docs/9.1/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL


--
Regards,
Richard Broersma Jr.

pgsql-odbc by date:

Previous
From: albert
Date:
Subject: MSAccess to postgres on Windows Currency type problem
Next
From: albert
Date:
Subject: Re: MSAccess to postgres on Windows Currency type problem