title: What is the form of my local postgresql database url?
body: <p>I am going through a flask/sqlalchemy tutorial 
  <a href="https://pythonhosted.org/Flask-SQLAlchemy/quickstart.html#a-minimal-application" rel="noreferrer">https://pythonhosted.org/Flask-SQLAlchemy/quickstart.html#a-minimal-application</a>
  and I configured my database url to be:
  postgres://username:password@localhost:5432/dbname</p>
  
  <p>when I run db.create_all() in the interactive python shell it doesn't throw any errors, but it doesn't do anything either. </p>
  
  <p>From what I understand it is supposed to create the User table with three columns; id, username, and email . </p>
  
  <pre><code>from flask import Flask, url_for, render_template 
  from flask.ext.sqlalchemy import SQLAlchemy
  
  app = Flask(__name__)
  
  app.config['SQLALCHEMY_DATABASE_URI'] = 'postgres://username:password@localhost:5432/dbname'
  
  db = SQLAlchemy(app)
  
  
  class User(db.Model):
      id = db.Column(db.Integer, primary_key=True)
      username = db.Column(db.String(80), unique=True)
      email = db.Column(db.String(120), unique=True)
  
      def __init__(self, username, email):
          self.username = username
          self.email = email
  
      def __repr__(self):
          return '&lt;User %r&gt;' % self.username
  
  app.debug = True
  
  
  
  @app.route("/")
  def hello():
      return render_template('hello.html')
  
  if __name__ == "__main__":
      app.run()
  </code></pre>