problems importing a dbf file - dbf2pg broken?

From: Andy Bernat <abernatj(at)cox(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: problems importing a dbf file - dbf2pg broken?
Date: 2005-01-22 23:01:24
Message-ID: 41F2DB44.1030702@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings,
I'm trying to import a dbf file into postgresql (ver. 7.4.5, running
under SuSE 9.0). It's too large to load into a spreadsheet and export
(2million + records). I've tried dbf2pg but, while it handles the text
columns correctly, it is very confused by the numeric columns: It
claims the values are invalid but they are fine, at least the first 30
thousand import fine into a spreadsheet. I've also tried creating an
ascii version with dbfreader.py and importing that but this program
doesn't convert the text fields correctly and randomly reaaranges the
columns. Any assistance will be greatly appreciated.
Regards,
Andy.

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-01-23 00:31:38 Re: Upgrade from v8rc5 to 8.0.0 fails
Previous Message Mike G. 2005-01-22 06:08:07 Re: Windows 2000 Pro Error on Install