<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div class="" style="">Hello,</div><div class="" style="">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 <span class="" style=""><span style="font-style: italic;" class="">select </span><span class="" style=""><span style="font-style: italic;" class="">AddGeometryColumn ('Customers','Coordinates',4326,'Point',2) </span>create the coordinate column. I am attempting to enter long and lat coordinates of off handwritten notes. The syntax I used is </span></span><span class="" style=""><span class="" style=""><span style="font-style: italic;" class="">insert
into Customers (Coordinates) </span><span style="font-size: 12pt;" class=""><span style="font-style: italic;" class="">value (-89.58124, 44.10570) </span>for the first entry</span></span><span class="" style="font-size: 12pt;"><span class="" style=""> with the following error message </span></span></span><span style="font-style: italic;">insert into Customers (Coordinates)</span></div><div class="" style=""><span style="font-style: italic;">value (-89.58124, 44.10570)</span></div><div class="" style=""><span style="font-style: italic;">ERROR: syntax error at or near "value"</span></div><div class="" style=""><span style="font-style: italic;">LINE 2: value (-89.58124, 44.10570)</span></div><div class="" style="">Would certainly appreciate help with this problem.</div><div class="" style=""><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida
Grande', sans-serif; font-style: normal; background-color: transparent;">Thanks,</div><div class="" style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: normal; background-color: transparent;">Evan Phillippi</div></div></body></html>