If you are using PostGIS 2.0, you can use the typmod syntax by adding "Z" to the geometry type. For example, Point -> PointZ:
CREATE TABLE my3d( gid serial primary key, geom geometry(PointZ), name character varying(20) not null ); Then you can use functions like ST_MakePoint [1] to construct a 3D geometry to put in the table: INSERT INTO my3d(geom, name) SELECT ST_MakePoint(3.1, 4.2, 5.1), 'a 3D point'; [1] http://www.postgis.org/docs/ST_MakePoint.html -Mike On 16 July 2012 22:22, josamulai <jmamu...@gmail.com> wrote: > Hello. > > How can to make a 3D table from a file with x, y, z information? > > Thank you. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Make-a-3D-table-in-PostGIS-tp4998971.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > 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