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

[Sandro Santilli]

Given C skills it would be lovely to have an Foreign Data Wrapper
for shapefiles...

On Tue, Nov 13, 2012 at 03:32:46PM -0500, Stephen Woodbridge wrote:
> 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.
> 
> -Steve