Re: adding data in one column

Поиск
Список
Период
Сортировка
От
Тема Re: adding data in one column
Дата
Msg-id Pine.LNX.4.10.10010061014120.5164-100000@chapelperilous.net
обсуждение исходный текст
Ответ на adding data in one column  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
Список 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 по дате отправления:

Предыдущее
От: Robert Kernell
Дата:
Сообщение: re: adding data in one column
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Using UnixODBC and postgresql