From: | marc_firth <marc(dot)r(dot)firth(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Add quto increment to existing column |
Date: | 2011-10-04 13:38:53 |
Message-ID: | 1317735533004-4868544.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you use the SERIAL (this is the auto-incrementing function that creates
sequences in the bankground for you) datatype you can accomplish it in one
go.
So:
DROP sequence hist_id_seq; -- Get rid of your old sequence
ALTER TABLE my_table DROP COLUMN hist_id; -- Remove id column
ALTER TABLE my_table ADD COLUMN hist_id SERIAL PRIMARY KEY; -- Recreate it
as Primary Key and quto-incrementing.
Btw: have you tried the http://www.pgadmin.org/ pgadmin gui for
postgres? It will help you do tasks like this and show you the SQL to do it
on the command line :)
Cheers,
Marc
Robert Buckley wrote:
>
> Hi,
>
> I have a column in a table called hist_id with the datatype "integer".
> When I created the table I assigned this column the primary key constraint
> but didn´t make it an auto-increment column.
>
> How could I do this to an the already existing column?
>
> I have created the sequence with the following command but don´t know how
> to change the existing column to auto-increment.
>
>
> $ create sequence hist_id_seq;
>
> thanks for any help,
>
> Rob
>
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Add-quto-increment-to-existing-column-tp4868404p4868544.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Phil Couling | 2011-10-04 14:28:02 | Re: Add quto increment to existing column |
Previous Message | Craig Ringer | 2011-10-04 13:09:05 | Re: How can i get record by data block not by sql? |