Hi Evan, Try using ST_MakePoint [1] to build a geometry. Furthermore, you may need to also use ST_SetSRID [2] to establish the SRID for the geometry.
insert into Customers (Coordinates) value ST_SetSRID(ST_MakePoint(-89.58124, 44.10570), 4326) -Mike [1] http://www.postgis.org/docs/ST_MakePoint.html [2] http://www.postgis.org/docs/ST_SetSRID.html On 13 June 2014 09:01, Evan Phillippi <[email protected]> wrote: > Hello, > My name is Evan. I am new to postgis and sql and am attempting to build a > databases to store and query data on soil moisture probes installed on farms > accross the US. I have successfully created a table with relevent columns > including a geometry. I used select AddGeometryColumn > ('Customers','Coordinates',4326,'Point',2) create the coordinate column. I > am attempting to enter long and lat coordinates of off handwritten notes. > The syntax I used is insert into Customers (Coordinates) value (-89.58124, > 44.10570) for the first entry with the following error message insert into > Customers (Coordinates) > value (-89.58124, 44.10570) > ERROR: syntax error at or near "value" > LINE 2: value (-89.58124, 44.10570) > Would certainly appreciate help with this problem. > > Thanks, > Evan Phillippi > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
