title: Rename mixed-case tables in a single query
body: <p>In my <code>PostgreSQL 9.2</code> database there are many tables having name with mixed cases,For example </p>
  
  <p><code>Tbl_Sales</code>,<code>Tbl_Purch</code>,<code>Tbl_logMnth</code> </p>
  
  <p>What I want to do is </p>
  
  <pre><code> alter table "Table1" rename to table1
  </code></pre>
  
  <p>but how to rename all mixed-case tables in my database in an easy way ?</p>