Hi Francesco, using FWTools (Open Source GIS/RS Binary Kit) offers you a really simple export. open FWTools Shell and use the ogr2ogr Lib.
Type something like this: ogr2ogr -f "ESRI Shapefile" "C:/tmp/mydata.shp" PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "SELECT name, the_geom FROM neighborhoods" greetings Simon -------- Original-Nachricht -------- > Datum: Fri, 14 Sep 2012 11:41:01 +0200 > Von: "Francois Hugues" <hugues.franc...@irstea.fr> > An: francescobocca...@libero.it, "PostGIS Users Discussion" > <postgis-users@postgis.refractions.net> > Betreff: [postgis-users] RE : Postgis 3 dimension geometry table > Hello, > > I'm not sure to understand your question. > > Did you try psql2shp ? > > You could also take a look to openjump, qgis or arcgis where you can add a > query layer and then export it to shp. > > Hugues. > > > -------- Message d'origine-------- > De: postgis-users-boun...@postgis.refractions.net de la part de > francescobocca...@libero.it > Date: ven. 14/09/2012 10:47 > À: postgis-users@postgis.refractions.net > Objet : [postgis-users] Postgis 3 dimension geometry table > > Hi all, > i have a question for you. I have a table with these properties: > > CONSTRAINT enforce_dims_geometry CHECK (st_ndims(geometry) = 3), > CONSTRAINT enforce_geotype_geometry CHECK (geometrytype(geometry) = > 'MULTILINESTRING'::text OR geometry IS NULL), > > i would like to export that table in shapefile or kml format (or any > external > format) but i don't find a good tool to do that. > Can you help me?Is there a way to do that? > > Francesco > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
