pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ALTER TABLE help. 2+ messages / 1 participants [nested] [flat]
* ALTER TABLE help. @ 2005-02-28 15:42 Marco Rademeyer <mrademeyer@pnp.co.za> 2005-03-01 05:25 ` ALTER TABLE help. Marco Rademeyer <mrademeyer@pnp.co.za> 0 siblings, 1 reply; 2+ messages in thread From: Marco Rademeyer @ 2005-02-28 15:42 UTC (permalink / raw) To: 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@pnp.co.za ^ permalink raw reply [nested|flat] 2+ messages in thread
* ALTER TABLE help. 2005-02-28 15:42 ALTER TABLE help. Marco Rademeyer <mrademeyer@pnp.co.za> @ 2005-03-01 05:25 ` Marco Rademeyer <mrademeyer@pnp.co.za> 0 siblings, 0 replies; 2+ messages in thread From: Marco Rademeyer @ 2005-03-01 05:25 UTC (permalink / raw) To: 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@pnp.co.za ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-01 05:25 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-02-28 15:42 ALTER TABLE help. Marco Rademeyer <mrademeyer@pnp.co.za> 2005-03-01 05:25 ` Marco Rademeyer <mrademeyer@pnp.co.za>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox