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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
