huge file to insert into postgres db
| From: | Matt MacLeod | 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