Update 160518-install-postgresql-python-3-ubuntu-1604.markdown

ronalddas · web-flow · commit 9bfc0ec9ee77 · 2019-05-10T15:02:20.000+05:30
Fixed Bug , which caused expection 'cursor already closed'
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)
