-- The point_test table is created with the single ST_Point column pt1. CREATE TABLE point_test (pt1 ST_Point); -- The ST_PointFromText function converts the point text coordinates -- to the point format before the INSERT statement inserts the point -- into the pt1 column. INSERT INTO point_test VALUES( ST_PointFromText('point(10.01 20.03)', 1000) );