title: How to delete every table in a specific schema in postgres?
body: <p>How do I delete all the tables I have in a specific schema? Only the tables in the schema should be deleted. 
  I already have all the table names that I fetched with the code below, but how do delete all those tables?</p>
  
  <p>The following is some psycopg2 code, and below that is the SQL generated</p>
  
  <pre><code>writeCon.execute("SELECT table_name FROM information_schema.tables WHERE table_schema='mySchema'")
  </code></pre>
  
  <p><code>SELECT table_name FROM information_schema.tables WHERE table_schema='mySchema'</code></p>