Re: Conversion from MS Access to Postgresql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Conversion from MS Access to Postgresql
Дата
Msg-id 8610.962094728@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Conversion from MS Access to Postgresql  ("Len Morgan" <len-morgan@crcom.net>)
Ответы How to dump from Postgre
Список 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 по дате отправления:

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: DateTime fields
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Transactions and web applications