Re: Conversion from MS Access to Postgresql

If you turn off the "Bool as Char" option in the driver, you get bool
in Postgres.

Please note that all of the work that I have done recently has been with
PostgreSQL V7.0.2 and the latest ODBC driver. Things are different with
older versions.

Cheers,
Stephen.

Mihai Gheorghiu <tanhq(at)bigplanet(dot)com> wrote:
> 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(at)sdc(dot)com(dot)au>
> 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 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(at)grouplinks(dot)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(at)sdc(dot)com(dot)au
> >Adelaide, South Australia. Voice: 08-8177 1595
> >Computing & Network solutions. Fax: 08-8177 0133
> >
> >

========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133