title: Postgres Psycopg2 Create Table
body: <p>i´m new to Postgres and Python. I´m trying to create a simple user table but i don´t know why it isn´t creating.
  The error message doesn´t appear,     </p>
  
  <pre><code>    #!/usr/bin/python
      import psycopg2
  
      try:
          conn = psycopg2.connect(database = "projetofinal", user = "postgres", password = "admin", host = "localhost", port = "5432")
      except:
          print("I am unable to connect to the database") 
  
      cur = conn.cursor()
      try:
          cur.execute("CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);")
      except:
          print("I can't drop our test database!")
  
      conn.close()
      cur.close()
  </code></pre>