[postgis-users] Trouble inserting coordinate values

[Evan Phillippi]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140612/653e6266/attachment.html>