Try adding a fake row.
Eduin Yesid Carrillo Vega Ingeniero Civil, Esp. Sistemas de Información Geográfica Centro de Investigación y Desarrollo en Información Geográfica Instituto Geográfico Agustín Codazzi - IGAC Cr 30 48-51 Tel +57 1 3694000 ext 4603 Bogotá D.C., Colombia On Fri, Feb 20, 2009 at 6:14 AM, Joukje Aris <[email protected]> wrote: > Hello list, > > Does anyone know if it is possible to export an empty PostGIS table or view > with no rows to a valid shapefile? > > When exporting a table or view with no rows in it, pgsql2shp returns "ERROR: > Cannot determine geometry type (empty table).". With ogr2ogr there is no > error message, but no shapefile either. I would like to extract the data > structure of the table into an empty shapefile, compared with the -p option > in shp2pgsql. > > Any ideas would be appreciated. > Joukje > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
