Re: Add columns to table; insert values based on row - Mailing list pgsql-general

On Thu, 1 Nov 2018, David G. Johnston wrote:

> That makes no sense to me...you already have 82 rows on the table so if you
> insert 82 more you'll have 164 which doesn't seem like what you would
> want...
>
> I would probably do:

David,

   The table already exists with four attribute columns and their data. I'm
adding four new columns and their data base on the existing row's value in
column site_nbr.

   Based on your and Adrian's responses I'll go ahead and enter the values
filled intert statements for each row.

Thanks,

Rich