PostGIS

ST_PointZ
Prev	8.3. Geometry Constructors	Next

ST_PointZ

8.3. Geometry Constructors

Name

ST_PointZ — Creates a Point with X, Y, Z and SRID values.

geometry +`*`+ST_PointZ*(`float `x, float y, float z, integer srid=unknown`)`;

Returns an Point with the given X, Y and Z coordinate values, and optionally an SRID number.

Enhanced: 3.2.0 srid as an extra optional argument was added. Older installs require combining with ST_SetSRID to mark the srid on the geometry.

SELECT ST_PointZ(-71.104, 42.315, 3.4, 4326)

SELECT ST_PointZ(-71.104, 42.315, 3.4, srid => 4326)

SELECT ST_PointZ(-71.104, 42.315, 3.4)