How to Auto Increment in phpPgAdmin

PostgreSQL Hosting 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:

PostgreSQL Auto Increment in phpPgAdmin

Get Adobe Flash player



PostgreSQL Hosting PostGIS FAQ United States United Kingdom GeoServer Hosting Datacentres PostgreSQL Dedicated PostGIS Dedicated PotgreSQL Tutorials PostGIS Hosting Germany FAQs GeoServer FAQ PostgreSQL FAQ Neatline Hosting GeoServer Dedicated SLA PgRouting Hosting