[postgis-users] pgsql2shp

[TECHER Jean David]

if u have a table called mama like this

foo       |      foofoo            |  the_geom
-------+------------------+-------------
......    |      ..........             |   ...........

with

foo :=> text

foofoo :=> text

the_geom => geometry

and u want only export foo and the_geom into a table called papa

Do

create table papa  as select into foo, the_geom from mama;

then

pgsql2shp -r  -f papap.shp -g the_geom your_datatabe mama
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site: http://techer.pascal.free.fr/postgis/
------------------------------------------------------------
----- Original Message -----
From: "TECHER Jean David" <davidtecher at yahoo.fr>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Wednesday, October 20, 2004 2:19 PM
Subject: Re: [postgis-users] pgsql2shp


> Hi,
>
> can you give an example of what u want???
>
> not easy to understand, not clear
> ----------------------------------------------------------------
> TECHER Jean David
> Responsable Informatique 01MAP
> e-mail: davidtecher at yahoo.fr
> site: http://techer.pascal.free.fr/postgis/
> ------------------------------------------------------------
> ----- Original Message -----
> From: "Nicol Hermann" <postgis at geoworld.de>
> To: <postgis-users at postgis.refractions.net>
> Sent: Wednesday, October 20, 2004 4:15 PM
> Subject: [postgis-users] pgsql2shp
>
>
> > Dear list,
> >
> > i there a possibility to narrow down the numer of datasets which will be
> > exported with pgsql2shp with a select statement or something similar?
> >
> > Many thanks
> > Nicol
> >
> > _______________________________________________
> > 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
>