Re: [GENERAL] dbf to pgsql

2005-08-04 Thread Brent Wood
On Thu, 4 Aug 2005, Piotr wrote: > 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. > A simplistic approach but workable would be to use the dbfinfo/dbfdump programs which are part of the

Re: [GENERAL] dbf to pgsql

2005-08-04 Thread Adrian Klaver
On Thursday 04 August 2005 01:42 am, Piotr wrote: You might to take a look at the following. http://www.klaban.torun.pl/prog/pg2xbase/ > 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. > > re

Re: [GENERAL] dbf to pgsql

2005-08-04 Thread Havasvölgyi Ottó
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,