I have started to learn pgAdmin III to manage a PostgreSQL database. But it wasn't an easy to use application.
If I create or have created a table with pgAdmin III, how can I add "auto-increment"-functionality on a column id that has type integer?
auto-incrementpgadminpostgresql
I have started to learn pgAdmin III to manage a PostgreSQL database. But it wasn't an easy to use application.
If I create or have created a table with pgAdmin III, how can I add "auto-increment"-functionality on a column id that has type integer?
Best Answer
two options: Use the "datatype" SERIAL or create a sequence and use this sequence as a default value for your integer: