Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group