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

From Peter Eisentraut
Subject Re: adding data in one column
Date
Msg-id Pine.LNX.4.21.0010061622490.949-100000@peter.localdomain
Whole thread Raw
In response to adding data in one column  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgaccess on Win95
Next
From: "Lissi Helena"
Date:
Subject: (Free) pgsql hosting?