Re: Conversion from MS Access to Postgresql
От | |
---|---|
Тема | Re: Conversion from MS Access to Postgresql |
Дата | |
Msg-id | 001a01bfe049$b748cfe0$0602010a@bullwinkle.vectormath обсуждение исходный текст |
Ответ на | Conversion from MS Access to Postgresql ("G.L.Lim" <limgl@grouplinks.com>) |
Список | 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@bigplanet.com> To: Stephen Davies <scldad@sdc.com.au>; G.L.Lim <limgl@grouplinks.com> Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.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 >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 >> >> >
В списке pgsql-general по дате отправления: