From: | Marco Rademeyer <mrademeyer(at)pnp(dot)co(dot)za> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | ALTER TABLE help. |
Date: | 2005-03-01 05:25:33 |
Message-ID: | 1109654733.26841.267.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi
I am quite new to PostgreSQL.
Could someone please help or gide me in the right direction.
My problem is that I have a table with about 15 billion entries. I need
to auto increment the table for the start and then every entry after
that.
I have create the field "num" that has the auto increment field set, but
it is only for the new fields that get added.
this is what I have done:
step one : CREATE TABLE num_table (num SERIAL);
step two : ALTER TABLE test_stock ALTER COLUMN num SET DEFAULT
nextval(num_table_num_seq');
But this is how far I got.
Regards
Marco
Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security(at)pnp(dot)co(dot)za
From | Date | Subject | |
---|---|---|---|
Next Message | Gourish Singbal | 2005-03-01 07:37:18 | Whats the file extention for custom format in pg_dump |
Previous Message | Margabandhu De.Sambath | 2005-03-01 02:06:53 | unsubscribe |