PostgreSQL Auto Increment

PostgreSQL Tutorials > Auto Increment

This video shows how to auto increment using phpPgAdmin. There are numerous uses for the auto-incrementing. Here, we are going to see how to auto-increment on a primary key.

In "Create a Table" we created a table, demotable. We set demotable_id as our primary key for our table.

In "Create a Sequence" we created a sequence, demo_id_seq.

While we will use the example table and sequence we created in this tutorial, the basic form is the same whenever adding auto-incrementing: .