We'll reuse our module from the previous notebook (00_database_connectivity_setup.ipynb) to establish connectivity to the database
In [1]:
%run '00_database_connectivity_setup.ipynb'
Your connection object is conn, you can run your queries using the magic command %%showsql or explicitly using psql.read_sql("""<YOUR SQL>""", conn). For CREATE/UPDATE/DELETE you can use the magic command %%execsql or explicity using psql.execute("""<YOUR SQL>""", conn), followed by a conn.commit().
In [ ]: