[postgis-users] insert interactively asc or text files

[Stephen Frost]

* 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

> On 7/4/07, pere roca <peroc79 at gmail.com> wrote:
>>
>>
>>   Hi everybody,
>>   I just was wondering if there is some tool to insert automatically data
>> from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
>> (something similar to shp2pgsql.exe).
>>
>>   What I want to do is that after a user inserts a file in our server,
>> automatically this file is inserted in someway to PostGIS. How would you
>> do
>> it?
>>
>>    Thanks!
>>    Pere
>> --
>> View this message in context: http://www.nabble.com/insert
>> -interactively-asc-or-text-files-tf4022887.html#a11426251
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> -- 
> Chetan Tiwari, Ph.D. (ABD)
> Dept. of Geography, The Univ. of Iowa
> 316 Jessup Hall, Iowa City, IA 52242
> Ph. (319) 335-0165 Fax (319) 335-2725

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070704/af0fee28/attachment.pgp>