Thanks to all who responded! As you mentioned Xbase really makes life easy
cf.http://www.startech.keller.tx.us/xbase/xbase.html
Knocked something together using it, and it looks uncannily like pg2xbase,
though the latter seems to need some fixing eg Pointer_to_Mem could be
initialised to prevent a spurious character followed by comma in
INSERT ( �,fieldname1,fieldname2)
Thanks again,
Patrick
Oleg Broytmann wrote on 21 Feb 1999:
> Hello!
>
> Just found on FreshMeat:
>
> http://w3.man.torun.pl/~makler/prog/pg2xbase.html
> Tool to convert Postgres to/from DBF files (required C++ and libxbase
> C++ library).
> Distribution license: GPL
Oleg Broytmann wrote on 8 Apr 1999:
> On Thu, 8 Apr 1999, Patrick Welche wrote:
> > 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 heared about some project called "xbase". Try to search FreshMeat for
> "xbase", "dbf postgres" or such...
Remigiusz Sokolowski wrote on 9 Apr 1999:
> http://w3.man.torun.pl/~makler/prog/pg2xbase.html
> this address is worth of checking - as I see - there are here utilities
> for convertion from and to postgres.
> Hope this helps
> Rem
Jim Mercer wrote on 8 Apr 1999:
> 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.
