title: Write to multiple tables using data obtained from a view in postgreSQL?
body: <p>I'm new to SQL and I have a large database that needs some cleanup. The way it is formatted is like this:  each table has a column containing an ID number and a second column containing some other type of information like so.</p>
  
  <ol>
  <li>Names: ID# Name</li>
  <li>Emails: ID# Email</li>
  <li>Phones: ID# Phone</li>
  <li>Notes: ID# Note</li>
  </ol>
  
  <p>I have a view that shows the information from all of these tables (in the actual database there are about 90 of them) and some code that takes each 'Note' and processes it into its individual components.  The notes are basically a jumble of all the other information combined, with a typical note reading:</p>
  
  <pre>
  First M. Last, Position Title, Phone 123-456-7890, Email abc@def.com
  </pre>
  
  <p>What I have now is code that iterates over all the notes in the view (~3 million) and identifies each element (phone, email, etc), but now I need to take these elements and write them to their respective columns in the other tables in the database.  I know that you can't write to a view as you can to a table and I'm not sure what the best strategy is for this seeing as I have so many notes to process. Can anyone help?</p>