Peter,
There is a dbf2pg in the contrib library, I have tried to use it, but I had
some probems with it: I had a numeric field whose decimal length was 0.
Dbf2pg couldn't handle this situation, it said that it has an illegel number
format. So I had to generate manually a big convertion script, and I fed to
psql.
EMS has a Data Import tool, it can handle DBF too.
Best Regards,
Otto
----- Original Message -----
From: "Piotr" <hokah@xxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, August 04, 2005 10:42 AM
Subject: dbf to pgsql
Hi,
Im lookig for tool to regulary transfer data from dbf files into pgsql.
Would be excellent if the tool would have data tranformation
possibility.
regards
Peter
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
