Microsoft products store false as (0) and true as
(-1) (Why? I don't know!). Apparently storing a
(-1) requires more than bool provides. So, you
can either edit all of your Access code so that it
interprets (1) as true (practically, I don't
recommend this), or you can migrate your yes/no
fields to int2.
From: Mihai Gheorghiu <tanhq(at)bigplanet(dot)com>
To: Stephen Davies <scldad(at)sdc(dot)com(dot)au>; G.L.Lim
Date: Tuesday, June 27, 2000 9:07 AM
Subject: Re: [GENERAL] Conversion from MS Access
>I tried to export an Access Yes/No field to pgsql
boolean and got an error
>By default, Access (and the ODBC driver) exports
Yes/No to bpchar. However,
>I want to use bool.
>From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
>To: G.L.Lim <limgl(at)grouplinks(dot)com>
>Date: Monday, June 26, 2000 7:54 PM
>Subject: Re: [GENERAL] Conversion from MS Access
>>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
>>3, fire up Access and Save/As/Export all tables
to the ODBC target.
>>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.
>>"G.L.Lim" <limgl(at)grouplinks(dot)com> wrote:
>>> I am curently using MS Access and would like
to convert my existing
>>> database to Postgresql database (maybe into
Postgresql dump file first if
>>> neccessary). Is there any utility or program
that can do that? Please
>>> Thank you.
>>> Geok Leng
>>Stephen Davies Consulting
>>Adelaide, South Australia. Voice:
>>Computing & Network solutions. Fax:
pgsql-general by date
|Next:||From: mikeo||Date: 2000-06-27 15:19:34|
|Subject: Re: trigger question |
|Previous:||From: Tom Lane||Date: 2000-06-27 14:52:55|
|Subject: Re: puzzled by the docs |