title: How can i get a count(*) of all the columns in a table? Using PostgreSql
body: <p>I have bunch of tables where several of them have hundreds of columns. I need to get a count of non-null values for each column and I've been doing it manually. I would like to figure out a way to get all the counts for all the columns in a table. I looked up stackoverflow and google, but unable to find the answer.</p>
  
  <p>I tried this but it's just returning a value of 1 for each column. I know it's just counting the number of column and not the values in each column. Any suggestions?</p>
  
  <pre><code>select count(COLUMN_NAME)
  from information_schema.columns
  where table_schema = 'schema_name'
  and table_name = 'table_name'
  group by COLUMN_NAME
  </code></pre>