[postgis-users] Adding geometry to an existing table
shaunlangley at gmail.com
Sat Apr 28 11:34:39 PDT 2012
I got myself into quite a mess and I'm hoping somebody out there can help me. I've created a database that includes in the range of 150 million records so far and I need to make a change to it. I have lat lon fields stored as strings in separate columns. What I would like to do is to take these 2 columns and created geometry column that combines both fields. I don't think there's a global function that will allow me to do this, but is there a way for me to use string formatting to do this easily?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users