title: Query to list number of records in each table in a database
body: <p>How to list row count of each table in the database. Some equivalent of </p>
  
  <pre><code>select count(*) from table1
  select count(*) from table2
  ...
  select count(*) from tableN
  </code></pre>
  
  <p>I will post a solution but other approaches are welcome</p>