title: Reset primary key of Postgres database with Django
body: <p>I was having terrible table issues because I had created my own user class than switched to the default Django class. After innumerable headaches, we decided to just do a clean <code>python manage.py reset</code> the <code>syncdb</code>. Created a new user, but the primary key counter for User.id began where the previous one left off, meaning that when creating other tables that use User.id as the primary key, they are always 14 off.</p>
  
  <p>How can I either rewipe fully so that they begin at 1, or alter the counter so it is now at 2 (since I created one user)? If it involves SQL, please also let me know where to put it, as my app is hosted on Heroku.</p>
  
  <p>Thanks!</p>