Re: alter existing table column with primary key to auto-increment

From: Rounak Jain <rounakjainis(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: alter existing table column with primary key to auto-increment
Date: 2017-02-05 10:57:44
Message-ID: CANNuxWMwOVmX7rNZvY=iKCK1LdJ1FigM8vC5kioLxOZQCSiKXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

alter table customer add column id serial primary key;
I want to know how to alter the column instead of dropping it.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2017-02-05 17:40:35 Re: alter existing table column with primary key to auto-increment
Previous Message Rounak Jain 2017-02-05 10:56:18 alter existing table column with primary key to auto-increment