[postgis-users] combine 2 columns into geometry column

[Donal Regan]

Hello.

What is the quickest way to combine 2 columns x and y into a single geometry column of type point?

Do I send the output of "select x,y from mytable" to a file (xy.out), then edit that file so that it each line has something like "INSERT INTO mytable (the_geom) VALUES (GeomFromText('POINT( 136.143781,35.816411 )',-1));" and then run

psql -d mydb -f xy.out

?

Is there a quicker way?

Cheers.


 		
---------------------------------
 Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060808/e24f2965/attachment.html>