I have a bunch of polygons in my CartoDB map, and I want to create a new column called
AREA in the table
MY_TABLE that contains values from my area calculation query:
select ST_Area(the_geom::geography) as area_sqm FROM My_TABLE
this statement works, but the column
area_sqm that contains the area value clears every time I clear the query, how can I have this permanently as part of my table so I can display the area value in the info table of my map?