[PHP-DB] Re: large csv text file import into postgresql via PHP

2003-09-26 Thread pete M
I've written and automated system that does the following:: similar problem ** every evening a cron job executes on LAN linux and spools of prices into a csv text file ** The file is ftp/uploaded to remote server on web and a database entry created to show file ** cron job on remote server

[PHP-DB] Re: large csv text file import into postgresql via PHP

2003-09-26 Thread pete M
oops forgot to mention reson for cron... Timeouts processing 143mb can take a long time. also you need to use fgets to read the file one line at a time.. pete Dave wrote: we have a number of csv dumps that occasionally have to be used to update tables in a postgres database... normally