Re: Conversion from MS Access to Postgresql

I tried to export an Access Yes/No field to pgsql boolean and got an error
message.
By default, Access (and the ODBC driver) exports Yes/No to bpchar. However,
I want to use bool.
Any suggestions?
Thanks,

Mihai


-----Original Message-----
From: Stephen Davies <scldad@sdc.com.au>
To: G.L.Lim <limgl@grouplinks.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Monday, June 26, 2000 7:54 PM
Subject: Re: [GENERAL] Conversion from MS Access to Postgresql


>G'day.
>
>Having just done it, I can confirm that converting an Access database
>to PostgreSQL is very easy.
>
>All I did was as follows:
>
>1. create an empty Postgresql database,
>2. cretae an ODBC DSN on the Access machine pointing at the empty
>database,
>3, fire up Access and Save/As/Export all tables to the ODBC target.
>
>Job done:-))
>
>In fact, I had to do some massage to the results as the export process
>does not create indexes nor sequences and I decidesd to change some of
>the generated data types.
>
>This was also easy using the pgdump utility to dump the data and the
>definition for editing.
>
>Be aware that any column names that include upper case letters in
>Access will keep their capitalisation and require quotes in Postgresql.
>
>HTH,
>Stephen.
>"G.L.Lim" <limgl@grouplinks.com>  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.
>>
>> Thank you.
>>
>> Regards,
>> Geok Leng
>
>
>
>
>========================================================================
>Stephen Davies Consulting           scldad@sdc.com.au
>Adelaide, South Australia.               Voice: 08-8177 1595
>Computing & Network solutions.       Fax: 08-8177 0133
>
>