[postgis-users] Export empty PostGIS table

Eduin Yezid Carrillo Vega yecarrillo at gmail.com
Fri Feb 20 05:14:54 PST 2009

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 <joukje.aris at gmail.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list