Merge pull request mattmakai#204 from josephpaulmckenzie/master

mattmakai · web-flow · commit b0402e3f937b · 2019-02-15T10:59:33.000-05:00
Added conn.commit() to actually save the table in the db
diff --git a/content/posts/160518-install-postgresql-python-3-ubuntu-1604.markdown b/content/posts/160518-install-postgresql-python-3-ubuntu-1604.markdown
@@ -163,6 +163,9 @@ and "password" values with your own.
         cursor.execute("""CREATE TABLE tutorials (name char(40));""")
         # 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)
     except Exception as e:
