title: Update empty column with Data from two other columns all varchar/text Postgresql
body: <p>I have 2 columns named type1 &amp; type2 in a table with the name table1 i need to populate their data to my newly created column models but not just to retrieve their data via query but to actually populate the new column "table1".models</p>
  
  <p>at the moment i can have what i want with the following query</p>
  
  <pre><code>select concat("table1".type1,' ',"table2".type2) as models
  from "table1";
  </code></pre>
  
  <p>I need an update column models command to actually populate the newly created column models in postgres.</p>
  
  <p>Thank you.</p>