[postgis-users] Is it possible to import shapefile from PL/PGSQL or using SQL command?

Stephen Woodbridge woodbri at swoodbridge.com
Tue Nov 13 12:32:46 PST 2012

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 you are handy with a 
little C code you might be able to write a stored procedure in C that 
mimics shp2pgsql and would be callable from SQL, but I'm not sure why 
you would want to do this.


More information about the postgis-users mailing list