title: How to insert values into the rows of a newly added column of a table in PostgreSQL
body: <p>I imported a personal geodatabase into PostgreSQL. For one of my tables, I added a new column. This column is empty and I want to add in/insert values into this column so that all its rows will be populated. When I used: </p>
  
  <pre><code>INSERT INTO district (province_id) VALUES
  ('13'), ('13'), ('13'), ('13'), ('13'),  ('13'), ('12'), ('12'), ('12'), ('12'), ('12'), ('12'), ('12'), ('12'), ('12'), ('19'), ('19');
  </code></pre>
  
  <p>The result is such that new rows were created, so instead of having 17 rows, I ended up having 34 rows. When I try to use UPDATE...Set...=... Where...., the query ran successfully, however, no row was affected. My question now is: how can I add the values for each of the rows in the newly created column such that no new rows will be created as a result?</p>
  
  <p>Thanks in advance and any help would be very much appreciated.</p>
  
  <p>Barbaara</p>