I am uploading 64 features from 64 shapefiles into the postgis server (I use INSERT TO to append them one by one), for some reasons I made some mistakes at the first attempt so I deleted them (except where
id = 1), then I re-upload them. However, the id (primary key generated automatically when uploading) does not start from 2 but from 65.
Why is postgis doing this? How do I change it back to start from 2? Also is there any way that I can arrange the table by the
id in an ascending order (so that when the user drag it into QGIS and open the attribute table, they can see that the features are arranged ascendingly)?