Search Postgresql Archives

Re: Add columns to table; insert values based on row

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux