Re: adding data in one column

From: Peter Eisentraut <peter_e(at)gmx(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:23:09
Message-ID: Pine.LNX.4.21.0010061622490.949-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2000-10-06 14:38:12 Re: Access to Postgres
Previous Message Peter Eisentraut 2000-10-06 14:22:24 Re: pgaccess on Win95