I have a PostgreSQL/PostGIS database. In my table I have columns for latitute and longitude and geometry. In the form the user provides latitute and longitude. Now I want to run the additional SQL command
UPDATE epichloe.epichloe_db_main SET geom = ST_GeomFromText('POINT($lat $lon)', 4326) WHERE id = $id when the form is saved.
Where would I include this?