[ADMIN] trobles in importing dbf file

2006-05-11 Thread giuseppe . derossi
Hi Guys, I'm a newbie in Postgres and hope my mail is not off topic. Well, I'm migrating from Mysql to PostGree in order to use the postgis features. I've some dbf files I've to import, so I've used the utility dbf2pg.exe ( I've installed the version 8.1 in win xp env). Now is there a way to add au

Re: [ADMIN] trobles in importing dbf file

2006-05-11 Thread Andy Shellam
e primary key. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: 11 May 2006 8:25 am > To: pgsql-admin@postgresql.org > Subject: [ADMIN] trobles in importing dbf file > > Hi Guys, > I

Re: [ADMIN] trobles in importing dbf file

2006-05-11 Thread Lane Van Ingen
TECTED] Sent: Thursday, May 11, 2006 3:25 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] trobles in importing dbf file Hi Guys, I'm a newbie in Postgres and hope my mail is not off topic. Well, I'm migrating from Mysql to PostGree in order to use the postgis features. I've some dbf fil

Re: [ADMIN] trobles in importing dbf file

2006-05-11 Thread Jim C. Nasby
BTW, your email almost got marked as spam: X-Spam-Status: No, score=4.1 required=5.0 tests=BAYES_00,DNS_FROM_RFC_ABUSE, NO_REAL_NAME,RCVD_HELO_IP_MISMATCH,RCVD_NUMERIC_HELO autolearn=no version=3.1.0 On Thu, May 11, 2006 at 09:24:35AM +0200, [EMAIL PROTECTED

Re: [ADMIN] trobles in importing dbf file

2006-05-12 Thread giuseppe . derossi
by db2pg.exe > - drop the old table > - rename the new table to the old table name by using > ALTER TABLE RENAME TO > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 3: