New : Remote data collection with AcuGIS Scout free with all plans
Image US +1 302 384 9810

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: .

Auto Increment



 

Have questions? Please contact us.

Clients and Sectors

Serving individuals and institutions in over 70 countries worldwide.
01

International

Image

International

International governmental institutions. Email gov@acugis.com

02

Government

Image

Government

Local, State, and Federal. Email gov@acugis.com

03

Academia

Image

Academia

Discounts for Academic institutions. Email edu@acugis.com

04

NGO

Image

NGO

Non-Governmental Organizations. Email edu@acugis.com

05

Research

Image

Research

Public and Private Research institutions. Email edu@acugis.com

Our Mission

Making your life easier

Our mission is to make your job easier. AcuGIS is a world-leader in making GIS accessible and easy to use. Our focus is on administration and providing you with the best possible hardware, software, network, tools, and support so you can focus on your business with confidence. At AcuGIS, we understand that the success of your application relies on experienced, skilled administration. AcuGIS is owned and operated by Cited, Inc. serving clients in over 70 countries worldwide since 2006. Our support staff combine years of GIS, PostgreSQL, Tomcat, and Linux administration. .

Cited, Inc.
Wilmington, Delaware