Re[2]: Conversion from MS Access to Postgresql

From: Yury Don <yura(at)vpcit(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re[2]: Conversion from MS Access to Postgresql
Date: 2000-06-27 04:40:26
Message-ID: 1933892104.20000627104026@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Len,

Once, Tuesday, June 27, 2000, 4:22:08 AM, you wrote:

LM> While we're on the subject of Access/Postgres, I have a consistent problem
LM> in moving tables between Access and Postgres. Access doesn't seem to want
LM> to export a fixed length character field (i.e., I have a text field that is
LM> 9 chars long but when the table is created in Postgres, it always comes out
LM> character varying(9) instead. I cannot seem to make Postgres join two
LM> tables when the type of one is char(9) and the other is character
LM> varying(9). The machine seems to go into an endless loop. A similar
LM> problem I have is with fix precision fields. I want to export a
LM> numeric(10,2) number from Access but they always end up numeric(30,6).

LM> Perhaps this is my punishment for using Access/Windows but that is not
LM> something I can change just yet. If you have any insight into why this
LM> might be happening or what I can do to fix it, I would appreciate it. BTW:
LM> Postgres 6.5.3 and Access97.

IMHO if you have a less or more complex database you can't convert it
into PostgreSQL fully automatically. I did it using Pgupt, it makes
sql scripts for databse schema, you can change them as you need and
then create database and load data into it.

--
Best regards,
Yury ICQ 11831432
mailto:yura(at)vpcit(dot)ru

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stanislas pinte 2000-06-27 06:29:00 connection time-outs
Previous Message Mitch Vincent 2000-06-27 04:23:04 Linux/Postgre question.