[postgis-users] insert interactively asc or text files
peroc79 at gmail.com
Thu Jul 5 00:59:56 PDT 2007
thanks for your references, the problem is that what I want is not to type
anything in console (psql) but to construct an automatic insertion to Db
(when the user uploads a "text" (.csv, .txt file) and send it to my server,
then it runs "something" to insert into a table). Shortly, what I want is to
let users see his point data (species occurences) in my web application;
when session finishes, data should disappear. So, I should construct a
script, maybe using COPY, but how to write such kind of scripts? some PDF,
web references to learn it?
I was thinking to restrict the data to insert (X,Y and species, genus,
family) and to have a pre-constructed table in PostGIS with these columns. I
suppose it should minimize much more the work and time to insert data and
should also make much easier the scripting.
Michael Fuhr wrote:
> On Wed, Jul 04, 2007 at 12:53:27AM -0700, pere roca wrote:
>> 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).
> Are you familiar with COPY (or psql's \copy)?
>> 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
> How are files being sent to the server? Can you explain in more
> detail how your system works and what you're trying to do?
> Michael Fuhr
> postgis-users mailing list
> postgis-users at postgis.refractions.net
View this message in context: http://www.nabble.com/insert-interactively-asc-or-text-files-tf4022887.html#a11442333
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users