|
|
 | | From: | Andy Bernat | | Subject: | problems importing a dbf file - dbf2pg broken? | | Date: | Sat, 22 Jan 2005 18:01:24 -0500 |
|
|
 | 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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
|
|
