Thanks, I thought of that. But that leaves me with the trouble of removing it afterwards in the shapefile and the table each time I export a table that happens to be empty at the time. I do need an exact match with the number of rows in the database. It would have been nice to produce the shapefile in one step, but maybe taking the extra steps is the only way.
Joukje On Fri, Feb 20, 2009 at 2:14 PM, Eduin Yezid Carrillo Vega < [email protected]> wrote: > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
