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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
