> Is there a dbase3 <=> postgresql converter available at all? I found
> dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as
>
> -p primary:
> Select the primary key. You have to give the exact
> field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key)
>
> which of course PostgreSQL does. Anyone know of something more recent?
i used the dbf2sql library to create a utility to dump dbf file into two
ascii text files.
one file generated is an sql create statement and the other is a series of
sql insert statements, "insert into table (attr, attr) values (val, val);"
for me, it was easy enough to modify the test files to my tastes with
external scripts or manual editting, than to rework the code to do actual
inserts.
feel free to have a look:
ftp://ftp.reptiles.org/pub/pgsql/dbf2sql-2.0-rep.tar.gz
this is the dbf2sql-2.0 stuff, plus the source for my program (mydb).
the makefile is minimally modified to my tastes.
--
[ Jim Mercer Reptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
