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 <[EMAIL PROTECTED]> wrote:

* Chetan Tiwari ([EMAIL PROTECTED]) 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to