PgDBF
Submitted by kirk on Thu, 06/26/2008 - 10:44
The PgDBF project is moving to its new home on SourceForge, at http://pgdbf.sourceforge.net/ . All new updates and code will be posted there.
The PgDBF project is moving to its new home on SourceForge, at http://pgdbf.sourceforge.net/ . All new updates and code will be posted there.
Generic converter
I was wondering if you have given any consideration to making a more generic converter. I am a programmer working for new York City trying to move my agency toward postgres. We currently use Informix, Oracle, and SQL Server. It would be wonderful if you could re-work your code to handle those conversions.
Alan Polinsky
polinsky@acm.org
Not likely
Thanks for the interest, but that's probably out of scope for the time I have available to work on it (busy job, small kids at home, etc.). Having said that, PgDBF's output is generic enough that it can probably go directly into other databases, particularly Oracle. For converting *from* any of those, I'd see if you could dump their tables into text files and manipulate those enough to get PostgreSQL to load them.
Issue with empty dates
Hello
Today i found pgdbf and tried to convert a customer dbf to postgresql. I found that when a date is empty in the dbf the program fails and doesn't insert the \N for that field, and postgrest fails when going to insert data.
I don't know C, but i'm sure the problem is here:
if(bufoffset[0] == ' ') {
printf("\\N");
}
Because bufoffset is empty (aka null) when reads an empty date. I've tried to fix and give you a patch but i don't know how compare bufoffset[0] to a null...
Hope you fix it.
Thank you by your work!
Best,
Jose Maria Terry (jtjremovethis-andthis@tssystems dot net)
Fixed in 0.3.5.
Fixed in 0.3.5.
Post new comment