| From: | <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Robert Kernell <kernell(at)sundog(dot)larc(dot)nasa(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: adding data in one column |
| Date: | 2000-10-06 14:15:54 |
| Message-ID: | Pine.LNX.4.10.10010061014120.5164-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 6 Oct 2000, Robert Kernell wrote:
> Suppose I have a table with data in it. Then I add a column. Now I want to add
> data to that column, in the rows that are already there. So I want to go to each
> row and add data to the new column in that row.
UPDATE <tablename> SET <newcolname>=<DATA> [WHERE CLAUSE]
Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
A candidate is a person who gets money from the rich and votes from the
poor to protect them from each other.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vilson farias | 2000-10-06 14:16:18 | Help needed : temp tables. |
| Previous Message | Robert Kernell | 2000-10-06 14:11:57 | re: adding data in one column |