[postgis-users] The_geom from default

[Stephen Crawford]

All,

Can 'the_geom' in a spatial table be set to a default to create the geometry
from the 'lat' and 'lon' columns?  I have table of farms as points that will
be updated occasionally; what I hope to achieve is that when a farm record
is added with lat and lon, the 'the_geom' field will automatically be
populated on insert.  Any good ideas on how to do this?

Thanks,
Steve

Stephen Crawford
Center for Environmental Informatics
GeoVISTA Center
The Pennsylvania State University