Hi,
Use the COPY command to load CSV to a table.
The rest depends if you want to display/use the geometry, or you're only
interested in the coordinates:
• Add a geometry column
• st_makePoint to build a point from coordinates
• A trigger to create the WGS84 point from coordinates with
*Nota ben*e
I have looked at the code of the extension and it's using the
raster2pgsql.py script.
Jean-Daniel
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Does anyone know of any way PostGIS can import a shapefile directly by
running an SQL statement (i.e. is there any function identical to shp2pgsql
that PostGIS defines in SQL during installation?)
Thanks in advance
--
View this message in context:
On 11/13/2012 3:20 PM, GregoryKramdia wrote:
Does anyone know of any way PostGIS can import a shapefile directly by
running an SQL statement (i.e. is there any function identical to shp2pgsql
that PostGIS defines in SQL during installation?)
No, don't think there is anything close to that. If