On Sat, 2004-11-06 at 18:56, Ed L. wrote:
On Saturday November 6 2004 2:13, Franco Bruno Borghesi wrote:
> the simplest way to do it seems to be adding a SERIAL column to your
> table, and then adding a primary key constraint:
>
> 1)insert data into table
> 2)ALTER TABLE <table> ADD id SERIAL;
> 3)ALTER TABLE <table> ADD CONSTRAINT <table>_pk PRIMARY KEY (id);
You may also need to populate the id column with unique values in between
these two steps with something like "
update table set id = nextval('table_id_seq'::text) where id isnull"
I don't think SERIAL does that for you.
Ed
<<attachment: smiley-4.png>>
signature.asc
Description: This is a digitally signed message part
