I am importing waypoints from GPS (in gpx format) using Layer>Add Vector layer and then I want to clean up the data and add some more attributes and finally add them to a master table in PostGIS.
The import works fine but I get a table with a lot of fields I don't need and the fields I do need in some cases have the wrong names nor can I modify the table without doing a save as and reloading it.
So I end up
- importing the layer,
- saving it as a in a format that I can modify
- importing it again
- clean up the data and add new attributes (using some of the fields i don't need)
Now I want to update the master table. The only way I can see of doing this is to save the layer as PostGIS (or do this in step 2) and then use SQL to do the update so I can select which fields I want inserted in which columns.
Is there a more stream lined way of doing this?
PS. I am guessing the answer is write a script to do it. To this end I have just purchased The PostGIS cookbook and the Pyqgis book but it will be a few weeks while they travel around the world.