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
>