Re: adding data in one column - Mailing list pgsql-general

From
Subject Re: adding data in one column
Date
Msg-id Pine.LNX.4.10.10010061014120.5164-100000@chapelperilous.net
Whole thread Raw
In response to adding data in one column  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
List 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.


pgsql-general by date:

Previous
From: Robert Kernell
Date:
Subject: re: adding data in one column
Next
From: Peter Eisentraut
Date:
Subject: Re: Using UnixODBC and postgresql