DM <dm.a...@gmail.com> wrote:

> Hi All,
>  
> I have a table test with columns name and value
>  
> test table
> name
> value
>  
> It has around 500 rows.
>  
> I added a new column id to the table,
>  
> Table test
> id,
> name,
> value
>  
> I am not sure how to insert numbers to my column id (1-500).

You can create a SEQUENCE and use this Sequence for that, an example:

test=# create table foo (name text);
CREATE TABLE
Zeit: 2,824 ms
test=*# copy foo from stdin;
Geben Sie die zu kopierenden Daten ein, gefolgt von einem Zeilenende.
Beenden Sie mit einem Backslash und einem Punkt alleine auf einer Zeile.
>> a
>> b
>> c
>> d
>> e
>> \.
Zeit: 5592,132 ms
test=*# create sequence foo_seq;
CREATE SEQUENCE
Zeit: 10,030 ms
test=*# alter table foo add column id int;
ALTER TABLE
Zeit: 0,347 ms
test=*# update foo set id = nextval('foo_seq');
UPDATE 5
Zeit: 0,379 ms
test=*# select * from foo;
 name | id
------+----
 a    |  1
 b    |  2
 c    |  3
 d    |  4
 e    |  5
(5 Zeilen)

Zeit: 0,241 ms
test=*#




Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to