title: Insert multiple data from subquery into another table in postgres sql
body: <p>I have table alpha with two columns</p>
  
  <pre><code>id   school_name
  </code></pre>
  
  <p>I have another table beta which has around 600 rows of data with following columns</p>
  
  <pre><code>id  school_name    school_state school_city
  </code></pre>
  
  <p>now i want to select school_name from beta and insert it into alpha</p>
  
  <p>something like</p>
  
  <pre><code>insert into alpha (school_name) values(select school_name from beta )
  </code></pre>
  
  <p>but for all data ,I know it can be done with procedures but pgsql doesn't support procedures unlike mysql ,so how to achieve it?</p>