title: How to store and manage a sql schema, with the ability to update and insert data
body: <p>I am wondering what the best way (or any way) to manage a database schema. I have a sql file with a bunch of statements like <code>CREATE TABLE Users { id SERIAL PRIMARY KEY ....};</code> which represents the schema for my database. </p>
  
  <p>I have postgres installed on my dev machine however am having trouble syncing the changes I make to the schema with the local database. Currently I just run drop the entire database and run the schema file on the database.</p>
  
  <p>I figure there has to be a better way I don't know about. I will also need to be able to set a database up for production when the project becomes more stabilized and obviously dropping a table in production wont work.</p>
  
  <p>Suggestions?</p>