Jules,
> I'm building a program that will convert out current database (foxpro
> tables with encrypted content) to postgresql. The program will read
> each .DBF file and create SQL statements in a textfile that I can feed
> into postgresql with 'dos2unix; pgsql -f statements.sql'.
Have you considered using COPY instead? You can have your Foxpro script dump
to tab-delimited text files, and a 500mb COPY load is less crash-prone than
500mb of SQL commands.
--
-Josh Berkus
Aglio Database Solutions
San Francisco