I currently have a shp file with ~300 points. This shp file stores a bore name, x, y, z, and a few other attributes.
In a test PostGIS database, via QGIS, I have imported that shp file, called 'collars'. I have then gone and added holes to the 'collars' table, adding 3 new rows with all the required data, boreid, x, y, z etc.
Unfortunately I have realised upon re-opening QGIS that the layer does not automatically display these new holes. I understand that as I didn't add anything into the 'geometry' column these news rows of data have no spatial locations in the PostGIS database.
What I would like to know is can I cause the layers spatial data to recalculate, based off the x and y values, every time I open QGIS or whenever new data is added so that this 'collars' layer becomes a 'live' linked layer displaying new data as it is added in?