[postgis-users] insert interactively asc or text files

[Chetan Tiwari]

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 at snowman.net> wrote:
>
> * Chetan Tiwari (chetan.tiwari at gmail.com) 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070704/d175152c/attachment.html>