How to add auto increment in postgreSQL?

Question

I am new to PostgreSQL. I was trying to create a table and tried to add a primary key and auto increment in same column and came up with an ERROR

ERROR:  syntax error at or near "SERIAL"
LINE 2:  upID int SERIAL primary key

Below is my Query

create table tblIK(
    upID int SERIAL primary key,
    upName varchar(100) NOT NULL,
    upMin varchar(100) NOT NULL,
    upMax varchar(100) NOT NULL,
    upYEAR Date NOT NULL,
    upMi varchar(100)NOT NULL,
    upIK varchar(100)NOT NULL
)

paul41 · Accepted Answer · 2019-11-24 14:06:38Z

1

SERIAL will create an integer column for you so you don't need to specify it.

create table tblIK(
    upID SERIAL primary key,
    upName varchar(100) NOT NULL,
    upMin varchar(100) NOT NULL,
    upMax varchar(100) NOT NULL,
    upYEAR Date NOT NULL,
    upMi varchar(100)NOT NULL,
    upIK varchar(100)NOT NULL
)

answered Nov 24, 2019 at 14:06

paul41

6961 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

brandonris1 · Accepted Answer · 2019-11-24 18:16:40Z

0

If you are using Django to construct the tables in the DB and you want an auto incrementing primary key, Django by default will creat an ID column which is an auto incrementing integer field. Saves you some lines of code :)

answered Nov 24, 2019 at 18:16

brandonris1

4453 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to add auto increment in postgreSQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related