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