Skip to main content
Construct a Point from X, Y and Z and an optional srid. If srid is not set, it defaults to 0 (unknown). Must use ST_AsEWKT function to print the Z coordinate.

​
Signatures

ST_PointZ (X: Double, Y: Double, Z: Double)

ST_PointZ (X: Double, Y: Double, Z: Double, srid: Integer)

​
Parameters

​
X
Double
required
The X coordinate (longitude).
​
Y
Double
required
The Y coordinate (latitude).
​
Z
Double
required
The Z coordinate (elevation).
​
srid
Integer
Spatial Reference Identifier.

​
Return type

The resulting geometry.

​
Example

SELECT ST_AsEWKT(ST_PointZ(1.2345, 2.3456, 3.4567))

POINT Z(1.2345 2.3456 3.4567)