Skip site navigation (1) Skip section navigation (2)

Re: Conversion from MS Access to Postgresql

From: <davidb(at)vectormath(dot)com>
To: "Mihai Gheorghiu" <tanhq(at)bigplanet(dot)com>, "Stephen Davies" <scldad(at)sdc(dot)com(dot)au>, "G(dot)L(dot)Lim" <limgl(at)grouplinks(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Conversion from MS Access to Postgresql
Date: 2000-06-27 15:09:34
Message-ID: 001a01bfe049$b748cfe0$0602010a@bullwinkle.vectormath (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Hi Mihai,

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.

David Boerwinkle

-----Original Message-----
From: Mihai Gheorghiu <tanhq(at)bigplanet(dot)com>
To: Stephen Davies <scldad(at)sdc(dot)com(dot)au>; G.L.Lim
Cc: pgsql-general(at)postgresql(dot)org
Date: Tuesday, June 27, 2000 9:07 AM
Subject: Re: [GENERAL] Conversion from MS Access
to Postgresql

>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.
>Any suggestions?
>-----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
>Date: Monday, June 26, 2000 7:54 PM
>Subject: Re: [GENERAL] Conversion from MS Access
to Postgresql
>>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.
>>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.
>>"G.L.Lim" <limgl(at)grouplinks(dot)com>  wrote:
>>> Hi,
>>> 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
>>> advise.
>>> Thank you.
>>> Regards,
>>> Geok Leng
>>Stephen Davies Consulting
>>Adelaide, South Australia.               Voice:
08-8177 1595
>>Computing & Network solutions.       Fax:
08-8177 0133

pgsql-general by date

Next:From: mikeoDate: 2000-06-27 15:19:34
Subject: Re: trigger question
Previous:From: Tom LaneDate: 2000-06-27 14:52:55
Subject: Re: puzzled by the docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group