<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=""><span class="" style="font-family: Arial, sans-serif; font-size: 13px;">Hello,</span></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><br class="" style=""></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style="">I am attempting to store some gps coordinates that i collected for a geospatial db in precision ag. I created a table with a geometry column called "Coordinates" using the command "Coordinates" geometry(Point,4326). I then populated the column using the command ST_SetSRID(ST_MakePoint(-89.53580,44.12101), 4326));</font></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class=""
style="">This populates the coordinate table with a string in WKB. Is there a way I can covert the output values of the entire column from WKB to the raw lat,lon values. I have tried the alter table command <span class="" style="background-color: rgb(247, 247, 247);">ALTER TABLE "Customers"ALTER COLUMN "Coordinates" TYPE geometry(St_AsLatLonText), 4326)); but with no luck. </span></font></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);"><br class="" style=""></span></font></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);">Im relatively new to sql and postgres, I would certainly appreciate any help.</span></font></div><div class=""
style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);"><br class="" style=""></span></font></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);">Thanks!</span></font></div><div class="" style="font-family: Arial, sans-serif; font-size: 13px;"><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);">Evan</span></font></div><div class="" style=""><font face="Arial, sans-serif" class="" style=""><span class="" style="background-color: rgb(247, 247, 247);"><br class="" style=""></span></font></div><div class="" style=""><br class="" style=""></div></div></body></html>