How to setup PostGIS with an existing database?

Question

I have a database which has one table, Schools. This table also has latitude and longitude columns as 'float' type. I have installed PostGIS. I have created a postgis database using template_postgis_20. I, then added a table with datatype geometry. Now, how do I transfer latitude and longitude to this table from another Schools table?

I am using this for a Django application. I need to make queries like find schools within 5 miles of a student's current location( latitude and longitude).

Answer 1

If you installed correctly postgis in your database, with the geometric functions I suggest you install and use south for that migration, first read the tutorial and then make a data migration