Re: Conversion from MS Access to Postgresql

While we're on the subject of Access/Postgres, I have a consistent problem
in moving tables between Access and Postgres. Access doesn't seem to want
to export a fixed length character field (i.e., I have a text field that is
9 chars long but when the table is created in Postgres, it always comes out
character varying(9) instead. 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. 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).

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

len morgan

-----Original Message-----
From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: G.L.Lim <limgl(at)grouplinks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Date: Monday, June 26, 2000 4:53 PM
Subject: Re: [GENERAL] Conversion from MS Access to Postgresql

>"G.L.Lim" wrote:
>>
>> Hi,
>>
>> I am curently using MS Access and would like to convert my existing
Access
>> database to Postgresql database (maybe into Postgresql dump file first if
>> neccessary). Is there any utility or program that can do that? Please
>> advise.
>
>I have a perl program which will load the .csv files you can dump from
>Access. That will only move the data, of course. I generally find it
>better to write a script to build the database by hand, but I think you
>can export a script from Access that will work without too much editing.
>
>Reply if you want my perl program.
>
>Cheers,
> Andrew.
>--
>_____________________________________________________________________
> Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
>Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
>Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
>