Merge branch 'master' of github.com:mattmakai/fullstackpython.com

mattmakai · mattmakai · commit 2adf7407892b · 2019-05-13T10:42:46.000-04:00
diff --git a/content/posts/160518-install-postgresql-python-3-ubuntu-1604.markdown b/content/posts/160518-install-postgresql-python-3-ubuntu-1604.markdown
@@ -164,10 +164,10 @@ and "password" values with your own.
         # run a SELECT statement - no data in there, but we can try it
         cursor.execute("""SELECT * from tutorials""")
         conn.commit() # <--- makes sure the change is shown in the database
-        conn.close()
-        cursor.close()
         rows = cursor.fetchall()
         print(rows)
+        cursor.close()
+        conn.close()
     except Exception as e:
         print("Uh oh, can't connect. Invalid dbname, user or password?")
         print(e)
