[postgis-users] Create a geom column from old data

[Zamil Murji]

Hello list,

I have a database all ready to go. It had two columns already defined (latitude and longitude). I want to use those two columns to create geoms under the proper SRID. Please help. I have 50000+ rows so I don't want to create each geom one at a time.

A step by step guide would be great. I already have a geometry column defined in the table called the_geom.

Thanks
Zamil