Hi Stephen
That's a good point. The way I've got things setup right now is that the files are first uploaded to a temp location and are then parsed into postgresql/postgis. I need to look into what you're suggesting and it's obviously a more efficient way of achieving the same result. Thanks,
Chetan
On 7/4/07, Stephen Frost <sfrost@...
> wrote:* Chetan Tiwari (chetan.tiwari@...) wrote:
> I have a little perl script that reads CSV files uploaded via a browser and
> inserts the data into a table in postgres. I'll be happy to share that with
> you. It's setup to run with active perl and apache on windows, but it would
> be fairly easy to tweak it to your system setup.
If you want to do it on-the-fly you can use CGI.pm and its upload-hook
to avoid any disk i/o on the web server (and avoid any temp file
creation, or limits due to space on the disk, etc).
Thanks,
Stephen
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
