title: How to compare two identicals tables data of each column in postgres?
body: <p>I want compare two table's all column values.The two table is identical tables means column number is same and primary key is same. can any one suggest query which compare such two tables in postgres.
  The query should give the column name and what is the two different value of two tables.Like this</p>
  
  <pre><code>pkey | column_name | table1_value | table2_value
  123  | bonus       |   1          |    0
  </code></pre>