Re: Conversion from MS Access to Postgresql - Mailing list pgsql-general

From Tom Lane
Subject Re: Conversion from MS Access to Postgresql
Date
Msg-id 8610.962094728@sss.pgh.pa.us
Whole thread Raw
In response to Re: Conversion from MS Access to Postgresql  ("Len Morgan" <len-morgan@crcom.net>)
Responses How to dump from Postgre  ("Morten W. Petersen" <morten@src.no>)
List pgsql-general
"Len Morgan" <len-morgan@crcom.net> writes:
> ...  I cannot seem to make Postgres join two
> tables when the type of one is char(9) and the other is character
> varying(9).  The machine seems to go into an endless loop.

What?  Specific example, please.

> A similar problem I have is with fix precision fields.  I want to
> export a numeric(10,2) number from Access but they always end up
> numeric(30,6).

I don't think our 6.5.* ODBC driver knows anything about numeric,
so you're probably going to get default numeric precision if you
go through it.  You might have better luck with 7.0.

            regards, tom lane

pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: DateTime fields
Next
From: Lincoln Yeoh
Date:
Subject: Re: Transactions and web applications