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@bigplanet.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@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
> >
> >
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
