Re: adding data in one column

Robert Kernell writes:

> 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 table SET newcolumn = 'data';

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/