title: How to find all rows with a NULL value in any column using PostgreSQL
body: <p>There are many <em>slightly similar</em> questions, but none solve precisely this problem.  "<a href="https://stackoverflow.com/questions/14488859/find-all-rows-with-null-values-in-any-column">Find All Rows With Null Value(s) in Any Column</a>" is the closest one I could find and offers an answer for SQL Server, but I'm looking for a way to do this in PostgreSQL.  </p>
  
  <p>How can I select only the rows that have NULL values in <em>any</em> column?</p>
  
  <p>I can get all the column names easily enough:</p>
  
  <pre><code>select column_name from information_schema.columns where table_name = 'A';
  </code></pre>
  
  <p>but it's unclear how to check multiple column names for NULL values.  Obviously this won't work:</p>
  
  <pre><code>select* from A where (
    select column_name from information_schema.columns where table_name = 'A';
  ) IS NULL;
  </code></pre>
  
  <p>And <a href="https://www.google.com/search?q=postgres+check+multiple+columns+for+null+values&amp;oq=postgres+check+multiple+columns+for+null+values&amp;aqs=chrome..69i57.22589j0j7&amp;sourceid=chrome&amp;es_sm=91&amp;ie=UTF-8#newwindow=1&amp;q=postgres+SQL+check+multiple+columns+for+null+values" rel="noreferrer">searching</a> has not turned up anything useful.</p>