PostgreSQL No Auto Increment function?

Question

I have a test application coded in Java for creating an indexed and non indexed table in a MySQL, PostgreSQL, Oracle and Firebird database (Amongst other things).

Is it simply a case that PostgreSQL doesnt allow the auto increment feature? If not, what is the normal procedure for having an indexed coloumn?

Thanks in advance

Answer 1

You may use SERIAL in PostgreSQL to generate auto increment field,

For eg:-

CREATE TABLE user (
userid SERIAL PRIMARY KEY,
username VARCHAR(16) UNIQUE NOT NULL
)

This will create userid as auto-increment primary key indexed. If you don't want this as primary key, just remove PRIMARY KEY.