[postgis-users] Export empty PostGIS table

[Eduin Yezid Carrillo Vega]

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
>
>