How can I add a 2nd serial integer key column to a table? (postgresql)

Question

I have a table with 8440 records with a natural (string) primary key. Now I just discovered that to support a legacy client, I need the records to have integer keys as well. what's the easiest way to add a serial INT column to this table with a unique constraint and populate it with integer values from 1 to 8440?

Denis de Bernardy · Accepted Answer · 2011-05-31 17:06:10Z

2

Alter the table, add a new not null column of type serial, with a unique key on it.

In Postgres, the serial type is a mere alias for the int type with a default value of nextval(some_sequence), the latter of which is created on the fly.

edited May 31, 2011 at 17:06

answered May 31, 2011 at 16:10

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

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

1 Comment

Mike Sherrill 'Cat Recall' Over a year ago

NOT NULL UNIQUE is closer to PRIMARY KEY.

Collectives™ on Stack Overflow

How can I add a 2nd serial integer key column to a table? (postgresql)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related