Re: MSAccess to postgres on Windows Currency type problem

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: albert <skarbat(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MSAccess to postgres on Windows Currency type problem
Date: 2011-09-12 00:25:48
Message-ID: CABvLTWGC2Db-Y3dne579gZh0Dx8usxpPxjfkpJP+r9_30Hsqew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Sun, Sep 11, 2011 at 3:08 PM, albert <skarbat(at)gmail(dot)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.

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message albert 2011-09-12 00:37:59 Re: MSAccess to postgres on Windows Currency type problem
Previous Message albert 2011-09-11 22:08:37 MSAccess to postgres on Windows Currency type problem