PostgreSQL - How to add auto increment primary key?
- From the data view, click on the Structure button, or press Cmd + Ctrl + ]
- Click the + Column button, or double click on the empty row to insert a new column.
- Name the column, use the serial datatype, and set NO value for the is_nullable field.
- Press Cmd + S to save the changes.