title: Reset PostgreSQL primary key to 1
body: <p>Is there a way to reset the primary key of a PostgreSQL table to start at 1 again on a populated table?</p>
  
  <p>Right now it's generating numbers from 1000000 and up. I want it all to reset and start to 1, keeping all my existing data intact.</p>