-- 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 a 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) );