huge file to insert into postgres db

From: Date: Tue, 22 Apr 2003 07:31:00 +0000
Subject: huge file to insert into postgres db
Groups: php.general 
Request: Send a blank email to php-general+get-144782@lists.php.net to get a copy of this message
Hi, I have a large CSV file containing UK postcodes with their n/e co-ordinates which I need to put into a postgresql database. Its become very hard to handle as my machine cannot handle the whole CSV file so I've been chopping it into more manageable pieces and creating PHP insert scripts with the 'chopped bits'. Unfortunately, my PC can only handle about 10000 records at a time and there are 2 million+. I don't have time to do 200 scripts, so does anybody have any further ideas. Matt

« previous php.general (#144782) next »