[postgis-devel] Would it be hard to write a Foreign Data Wrapper from shp2pgsql code?

[Paragon Corporation]

Nicklas,

I beat you to that thought and already ticketed a while ago.

http://trac.osgeo.org/postgis/ticket/974

We might be some of the ways there since wie have libgdal dependency in
PostGIS 2.0 with raster.  We are only using the raster part, but the ogr
stuff I think is in the library too.

Bborie,Jorge, Paul (his fgdb thing) might have better sense of how much work
is involved since they've been hooking in the bindings between PostGIS and
GDAL.
 
Thanks,
Regina

> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net 
> [mailto:postgis-devel-bounces at postgis.refractions.net] On 
> Behalf Of Nicklas Avén
> Sent: Wednesday, November 30, 2011 3:44 AM
> To: postgis-devel at postgis.refractions.net
> Subject: [postgis-devel] Would it be hard to write a Foreign 
> Data Wrapper from shp2pgsql code?
> 
> Hallo
> 
> I have just learned about Foreign Data Wrappers in PostgreSQL.
> 
> If we would have a FDW from shapefiles or even ogr-based FDW 
> for all ogr formats, it would be possible to use all PostGIS 
> functionality directly on external files.
> 
> It could also be a way of importing data to PostGIS with the 
> possibility to use all PostGIS functionality in the import process.
> 
> 
> The PostgreSQL doc how to do it is here:
> http://www.postgresql.org/docs/9.1/static/fdwhandler.html
> 
> 
> Would it be a big thing or is most of the functionality 
> already in shp2pgsql and/or ogr library
> 
> How much funding would be needed to get someone to do it?
> 
> Just a thought 
> 
> /Nicklas
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>