title: Copy rows from one table onto another using INSERT query
body: <p>I have a table with 158 columns and 22,000 rows and I have another empty table where I want insert values dynamically based on the WHERE condition coming from the user. The SELECT query will look something like this:</p>
  
  <p>SELECT * FROM mygrist_tables WHERE suic_att>=5 AND gender='M'</p>
  
  <p>This gives me about 9,000 records back (say). I want to insert these records into another table (just this filtered data). Is it possible? Could anyone give me an idea of how the INSERT query would look like and whether I need to create another table with all those 158 cloumns or could the INSERT query dynamically create all those 158 columns? Also, could I do this using a view or would a table be essential? Thanks in advance!</p>