On Mon, Mar 31, 2014 at 05:25:44PM +0200, Rémi Cura wrote: > 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?
And what does pgsql2shp print in the header ? Like: Initializing... Done (postgis major version: 2). Output shape: PolyLineZ Also, first line of output from pgsql2shp invoked with no arguments ? --strk; > 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 -- () ASCII ribbon campaign -- Keep it simple ! /\ http://strk.keybit.net/rants/ascii_mails.txt _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users