Postgres Pro
Downloads
Home   >   mailing lists

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

From albert
Subject Re: MSAccess to postgres on Windows Currency type problem
Date
Msg-id CAGt3jCo=5BSFfLrWsxt1FPs0stUbhTJdJArZSeAZWdMKACUtDQ@mail.gmail.com
Whole thread Raw
In response to Re: MSAccess to postgres on Windows Currency type problem  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: MSAccess to postgres on Windows Currency type problem  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-odbc
Tree view
The problem is how can I get MSAccess translate that column type properly?
Why would I need to change that manually? I have a bunch of columns of such type.
The process just stops half way through there's no way I can export that table.

Additionally, I have tried to change that column type from within access to all numeric variants, even to text type,
prior to exporting it. Access stops half way through complaining about "not enough memory", which doesn't make sense.
The table has over 620.000 rows.

2011/9/11 Richard Broersma <richard.broersma@gmail.com>
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: Richard Broersma
Date:
Subject: Re: MSAccess to postgres on Windows Currency type problem
Next
From: Richard Broersma
Date:
Subject: Re: MSAccess to postgres on Windows Currency type problem