[postgis-users] Extract data with Lat Long

[Kevin Neufeld]

Look at:

http://www.postgresql.org/docs/8.3/static/sql-copy.html

and either update the geometry column afterwards, or put a trigger on 
your target table, updating the geometry.
-- Kevin

Andre Schoonbee wrote:
> I have imported shapefiles (POI information) into my Postgis database. It
> works 100%. Now, I would like to export that same data as CSV, but at the
> same time get a LAT, LONG coordinate for each POI. Help would be
> appreciated!
> 
> Secondly, How do I import CSV file with LAT LONG into Postgis and
> automatically populate the_geom field?
> 
> Andre
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users