[postgis-users] Export empty PostGIS table

[Joukje Aris]

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 <
yecarrillo at gmail.com> 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 <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
> >
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090220/9164082d/attachment.html>