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
|
| Список | 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.
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 programthe postgresql data type you want is NUMERIC.
> and it works correctly, translating it to postgres "money" data type.
http://www.postgresql.org/docs/9.1/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
--
Regards,
Richard Broersma Jr.
В списке pgsql-odbc по дате отправления: