it outputs 2. creation of the table is more than explicit :
DROP TABLE IF EXISTS registration_joined_with_trajectory; CREATE TABLE registration_joined_with_trajectory ( ... ,geom geometry(LinestringZ,931008) ,geom_surf geometry(PolygonZ,931008) ) What do you think? Cheers, Rémi-C 2014-03-31 17:14 GMT+02:00 Sandro Santilli <s...@keybit.net>: > On Mon, Mar 31, 2014 at 05:06:57PM +0200, Rémi Cura wrote: > > Hey, > > my pgsql2shp doesn't output 3D (but 2D). > > > > Am I missing something ? > > > > /usr/lib/postgresql/9.3/bin/pgsql2shp -f registration_surf_3D -h > localhost > > -p 5433 -u postgres -P uGuess -g geom_surf -r import_xml > > public.registration_joined_with_trajectory > > > > I have the latest postgis/geos/postgres/gdal. > > > > Of course ST_AsText output 3D geometry, > > the table is defined as geometry(polygonZ, XXXX) > > What does this give you ? > > SELECT max(ST_zmflag("geom_surf"::geometry)) > FROM public.registration_joined_with_trajectory; > > --strk; > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users