Added commit to actually save the table in the db

josephpaulmckenzie · web-flow · commit 980b5774cb07 · 2019-02-14T17:08:03.000-05:00
Need to add conn.commit() to save the table else when you go to view the table in a db manager it will not exsist
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:
