title: Django + PostgreSQL: How to reset primary key?
body: <p>I have been working on an application in Django.   To begin with, for simplicity, I had been using sqlite3 for the database.</p>
  
  <p>However, once I moved to PostgreSQL, I've run into a bit of a problem: the primary key does not reset once I clear out a table.</p>
  
  <p>This app is a game that is played over a long time period (weeks).  As such, every time a new game starts, all of the data is cleared out of the database and then new, randomized data is added.</p>
  
  <p>I'd like to be able to "start over" with primary keys starting at <code>1</code> each time I clean/rebuild the game.   </p>
  
  <p>The code still works as-is, but integers are a pretty natural way for describing the objects in my game.   I'd like to have each new game start at 1 rather than wherever the last game left off.</p>
  
  <p>How can I reset the primary key counter in PostgreSQL?   Keep in mind that I don't need to preserve the data in the table since I am wiping it out anyway.</p>