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@catalyst.net.nz>
To: G.L.Lim <limgl@grouplinks.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.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@cat-it.co.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
>