Postgres Pro
Downloads
Home   >   mailing lists

[NOVICE] alter existing table column with primary key to auto-increment - Mailing list pgsql-novice

From Rounak Jain
Subject [NOVICE] alter existing table column with primary key to auto-increment
Date
Msg-id CANNuxWPgcdygHPNqenfC3Ma_qpxHCO=2FTPoZZjpNS88TdwWiA@mail.gmail.com
Whole thread Raw
Responses Re: [NOVICE] alter existing table column with primary key to auto-increment
List pgsql-novice
Tree view
I am just starting with psql.
I have created surrogate id keys in some tables.
They are primary keys.
I want to add auto-increment to them.
I can drop and then create new columns like this:

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [NOVICE] Trouble with IN operator
Next
From: Rounak Jain
Date:
Subject: Re: [NOVICE] alter existing table column with primary key to auto-increment