When I enter edit mode of a PostGIS layer in QGIS 1.8 and add a feature, is it possible to auto-increment the ID?
I always have to look what last used ID was and manually enter a new one. I can't believe I'm the first one facing this problem.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
You should do that on your table in postgres
ALTER TABLE your_table ADD COLUMN idcolumn BIGSERIAL PRIMARY KEY;
QGIS will auto increment that ID for you, well Postgres does and QGIS will just read it back once you save.