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'.
The database is something like 500Mb on disk and testruns have showed
that the files containing the SQL statements will be larger than that.
I can choose to create a lot of relatively small .SQL files, or create
one huge one. Any recommendations? Will 'pgsql -f' choke on a > 500Mb
TIA for any pointers / help.
pgsql-novice by date
|Next:||From: Wim||Date: 2002-07-24 12:17:59|
|Subject: Advantage of using cursors...|
|Previous:||From: Technosol||Date: 2002-07-24 10:47:21|
|Subject: Problem connecting to Postgresql and creating databases|