From: | arun kv <arun(at)library(dot)iisc(dot)ernet(dot)in> |
---|---|
To: | PGSQL <pgsql-php(at)postgresql(dot)org> |
Subject: | Copy column contents |
Date: | 2002-07-24 05:58:53 |
Message-ID: | Pine.BSO.4.44.0207241120320.2333-100000@library.iisc.ernet.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
hai,
I have a database table with 8 fields and i want to add a new
column and copy the contents of one column to new column. if i try using
select and insert number of rows is duplicating and insertion is going to
end. how do i insert that contents to same row.
i am getting something like :
title | id | web | email | name
aaa | 11 | | |
bbb | 22 | | |
ccc | | | |
| | | |aaa|
| | | |bbb|
| | | |ccc|
but i want as
title | id | web | email | name
aaa | 11 | | |aaa|
bbb | 22 | | |bbb|
ccc | | | |ccc|
pls can anyone help me how do i go about this updation.
thanks
Arun
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2002-07-24 06:08:11 | Re: Copy column contents |
Previous Message | qfb10cller | 2002-07-23 10:26:35 | As low as 10 cents on the Dollar! dfw |