[postgis-users] Make a 3D table in PostGIS

[Mike Toews]

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 <jmamuedo at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users