Re: dbf to pgsql

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@wp.pl>
To: <pgsql-general@postgresql.org>
Sent: Thursday, August 04, 2005 10:42 AM
Subject: [GENERAL] 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
>
>