The ST_Point() function

The ST_Point() function returns an ST_Point, given an X-coordinate, Y-coordinate, and spatial reference ID.

Syntax

ST_Point(X double precision, Y double precision, SRID integer)

Return type

ST_Point

Example

The following CREATE TABLE statement creates the point_test table, which has a single point column, pt1:
CREATE TABLE point_test (pt1 ST_Point);
The ST_Point() function converts the point coordinates into an ST_Point geometry before the INSERT statement inserts it into the pt1 column:
INSERT INTO point_test VALUES(
   ST_Point(10.01,20.03,1000)
);