Postgres Pro
Downloads
Home   >   mailing lists

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

From Rounak Jain
Subject Re: [NOVICE] alter existing table column with primary key to auto-increment
Date
Msg-id CANNuxWMwOVmX7rNZvY=iKCK1LdJ1FigM8vC5kioLxOZQCSiKXQ@mail.gmail.com
Whole thread Raw
In response to [NOVICE] alter existing table column with primary key to auto-increment  (Rounak Jain <rounakjainis@gmail.com>)
List pgsql-novice
Tree view
alter table customer add column id serial primary key;
I want to know how to alter the column instead of dropping it.



pgsql-novice by date:

Previous
From: Rounak Jain
Date:
Subject: [NOVICE] alter existing table column with primary key to auto-increment
Next
From: Tom Lane
Date:
Subject: Re: [NOVICE] alter existing table column with primary key to auto-increment