Re: MSAccess to postgres on Windows Currency type problem

Поиск
Список
Период
Сортировка
От albert
Тема Re: MSAccess to postgres on Windows Currency type problem
Дата
Msg-id CAGt3jCo=5BSFfLrWsxt1FPs0stUbhTJdJArZSeAZWdMKACUtDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: MSAccess to postgres on Windows Currency type problem  (Richard Broersma <richard.broersma@gmail.com>)
Ответы Re: MSAccess to postgres on Windows Currency type problem  (Richard Broersma <richard.broersma@gmail.com>)
Список pgsql-odbc
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Richard Broersma
Дата:
Сообщение: Re: MSAccess to postgres on Windows Currency type problem
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: MSAccess to postgres on Windows Currency type problem