[Gdal-dev] ogr2ogr : creating Multipolygones shapefiles from Postgis

[Marc Jacquin]

Hi all,

For example this works fine for polygons:
Ogr2ogr -f "ESRI Shapefile" d:/test.shp PG:"dbname=xxxx user=xxx host=xxx
password=xxx port=xxx" -sql "select the_geom from mytable where .... "

If you use it with a multipolygon PostGIS geometry, it creates an empty Line
shapefile.

I could get around by using the where clause instead of the sql clause:

Ogr2ogr -f "ESRI Shapefile" d:/test.shp PG:"dbname=xxxx user=xxx host=xxx
password=xxx port=xxx" mytable -where "...."

Should I file a bug? 

I use the binary version of FWTools 1.10.

Regards,

Marc